If a cursor is named location_cursor,and you are using a LOOP ...EXIT WHEN loop to process the cursor,what is the exit condition for the loop?
A)location_cursor.DONE
B)location_cursor%DONE
C)location_cursor.NOTFOUND
D)location_cursor%NOTFOUND

Question

Quizplus · Accepted Answer

The exit condition for a LOOP ...EXIT WHEN loop with a cursor is typically when the cursor%NOTFOUND attribute is TRUE, indicating that there are no more rows to process. Therefore, choice D, location_cursor%NOTFOUND, is the best option.

If a Cursor Is Named Location_cursor,and You Are Using a LOOP