After running an UPDATE statement, the database server returns a count of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following tutorial:

CREATE TABLE emp_temp AS SELECT * FROM employees;

BEGIN

UPDATE emp_temp SET salary = salary * 1.05

WHERE salary < 5000;

DBMS_OUTPUT.PUT_LINE('# of rows updated: ' ||

SQL%ROWCOUNT);

END;

/

# of rows updated: 49