Google News
logo
PL/SQL - Interview Questions
In what cursor attributes the outcomes of DML statement execution are saved?
The outcomes of the execution of the DML statement is saved in the following 4 cursor attributes :

SQL%FOUND : This returns TRUE if at least one row has been processed.

SQL%NOTFOUND : This returns TRUE if no rows were processed.

SQL%ISOPEN : This checks whether the cursor is open or not and returns TRUE if open.

SQL%ROWCOUNT : This returns the number of rows processed by the DML statement.
Advertisement