Thursday, June 11, 2009

What are cursor attributes?

What are cursor attributes?
Cursor attributes are used to get the information about the current status of your cursor. Both explicit and implicit cursors have four attributes, as shown:Name Description%FOUND Returns TRUE if record was fetched successfully, FALSE otherwise.%NOTFOUND Returns TRUE if record was not fetched successfully, FALSE otherwise.%ROWCOUNT Returns number of records fetched from cursor at that point in time.%ISOPEN Returns TRUE if cursor is open, FALSE otherwise.

0 comments:

Post a Comment