%FOUND attribute is TRUE when cursor has remaining rows to fetch - PL/SQL Control Structures
Q. In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?- Published on 08 Jul 15a. %ROWCOUNT
b. %FOUND
c. %NOTFOUND
d. %ISOPEN
ANSWER: %FOUND
The %FOUND is a cursor attribute. The return value will be TRUE if the DML statements have an affect on atleast one row and the SELECT...INTO statement also returns atleast one row.
The return value will be FALSE if the DML statements do not affect any row and the SELECT...INTO statement does not return any row.
