Friday, 25 May 2012

What will be the value of %N0TF0UND attribute after a cursor is opened but before a FETCH statement is executed? | PL SQL

 The value of %NOTFOUND attribute will be NULL after the cursor is opened but before the FETCH statement is executed. After the FETCH statement, the value of %NOTFOUND attribute will be TRUE OR FALSE depending on the result of the FETCH statement.