Search notes:

Oracle: cursor attribute %rowcount

The cursor attribute %rowcount stores the amount of records that were affected by the most recent execution of the cursor on which the attribute is applied.
For implicit cursors, sql%rowcount can be used.

See also

The SQL Server equivalent for %rowcount seems to be @@rowcount.

Index