1.

What Are The Attributes Of Cursor?

Answer»

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.

Attributes of Cursor are :

%FOUND : 

%NOT FOUND :

%ISOPEN :

%ROWCOUNT :


Discussion

No Comment Found

Related InterviewSolutions