Various Cursor Attributes

SQL%ROWCOUNT: Number of rows affected by most recent SQL statement.

SQL%FOUND: Boolean attribute that evaluates to TRUE if most recent SQL statement affects one or more rows.

SQL%NOTFOUND: Boolean attribute that evaluates to TRUE if most recent SQL statement does not affect any row.

SQL%ISOPEN: Always evaluates to FALSE because P/L SQL closes implicit cursors immediately after they are executed