Attributes every explicit cursor & cursor variable have - SQL Operations

Q.  How many attributes does every explicit cursor and cursor variable have?
- Published on 03 Jul 15

a. 3
b. 2
c. 4
d. 5

ANSWER: 4
 
The 4 attributes are: %FOUND, %ISOPEN %NOTFOUND, and %ROWCOUNT. When these attributes are appended with the cursor or the cursor variable they return useful information about the execution of a data manipulation statement.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)