Google News
logo
Oracle - Interview Questions
What are the attributes of Cursor?
Attributes of Cursor are :
 
%FOUND :
* Returns NULL if cursor is open and fetch has not been executed
* Returns TRUE if the fetch of cursor is executed successfully.
* Returns False if no rows are returned.
 
%NOT FOUND :
* Returns NULL if cursor is open and fetch has not been executed
* Returns False if fetch has been executed
* Returns True if no row was returned
 
%ISOPEN :
* Returns true if the cursor is open
* Returns false if the cursor is closed
 
%ROWCOUNT :
* Returns the number of rows fetched. It has to be iterated through entire cursor to give exact real count.
Advertisement