Attributes of explicit cursor

a. %FOUND - True, if the SQL statement has changed any rows.
b. %NOTFOUND - True, if record was not fetched successfully.
c. %ROWCOUNT - The number of rows affected by the SQL statement.
d. %ISOPEN - True, if there is a SQL statement being associated to the cursor or the cursor is open.

Oracle - Explain the attributes of explicit cursor - April 10, 2009 at 11:00 AM

Explain the attributes of explicit cursor.  

There are four attributes of explicit cursor in oracle.

%IsOPEN
This evaluates TRUE when cursor is open else FALSE.

%FOUND
This evaluates TRUE if last fetch succeeded.

%NOTFOUND
Evaluates TRUE if last fetch failed.

%ROWCOUNT
This returns number of record fetched from active set.

Also read

Oracle cursors interview questions

What a SELECT FOR UPDATE cursor represent?, What WHERE CURRENT OF clause does in a cursor?, Can you pass a parameter to a cursor?, Explain the functioning of CURSOR FOR LOOP with example., Define Simple/Explicit , Parametric and Internal/Implicit cursor............

What is the difference between REF Cursor & Normal Cursor in oracle?

Normal cursors fall under the category of static cursors while REF cursors are dynamic.........

What is use of a cursor variable in oracle?

A cursor variable works like pointer in C. It is used to hold address of an item rather than the item itself. Cursor variables can be used to hold different values at run time............

What are the drawbacks of a cursor?

Implicit cursors are less efficient than explicit cursors, Implicit cursors are more vulnerable to data errors...........

What is a cursor variable?

A cursor variable is capable to get associated with different SELECT statements at run time. It is a reference type which is quite similar to pointer in C. In order to use cursor variable............ 

<<Previous  Next>>

Write your comment - Share Knowledge and Experience