PL/SQL Implicit Cursor Attributes

Oracle allows you to access information about the most recently executed SQL statement (INSERT, UPDATE, DELETE and MERGE) by referencing one of the following special implicit cursor attributes:

Name	Description
SQL%FOUND	Returns True if one or more rows were modified (created, changed, removed) successfully.
SQL%NOTFOUND	Returns True if no rows were modified by the DML statement.
SQL%ROWCOUNT	Returns the number of rows modified by the DML statement.
SQL%ISOPEN	Always returns FALSE for implicit cursors in DML statements.

Remember that you can also use the above on explicit cursors:

DECLARE

    TYPE var_cur_type is REF CURSOR;
    var_cur var_cur_type;
BEGIN
    IF NOT var_cur%ISOPEN THEN
        OPEN var_cur;
    END IF;

    -- Other code goes here
END;