Attributes of implicit 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 implicit cursor - April 10, 2009 at 11:00 AM by

Explain the attributes of implicit cursor  

There are four attributes of implicit cursor in oracle.

SQL%IsOPEN
Implicit cursor always returns FALSE as it gets closed automatically.

SQL%FOUND
Returns true when DML statement has affected at least one row else returns false.

SQL%NOTFOUND
Returns TRUE even one row of the table is affected.

SQL%ROWCOUNT
Returns number of rows affected by DML command.

Also read

What is a package cursor?

In a package cursor, the SQL statement for the cursor is attached dynamically at runtime from calling procedures............

Explain why cursor variables are easier to use than cursors.

They are easier to define as there is no need to specify a query statement, The query can also be specified dynamically at the opening time...........

What is locking, advantages of locking and types of locking in oracle?

Locking protect table when several users are accessing the same table. Locking is a concurrency control technique in oracle. It helps in data integrity while allowing maximum.........

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..............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience