In what cursor attributes the outcomes of DML statement execution are

1.	In what cursor attributes the outcomes of DML statement execution are saved?
Answer» 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.

Discussion