1YOU SHOULD USE SQL%rowcount HERE IS AN EXAMPLE
2
3set serveroutput ON;
4DECLARE
5 i NUMBER;
6BEGIN
7 UPDATE employees
8 SET status = 'fired'
9 WHERE name LIKE '%Bloggs';
10 i := SQL%rowcount;
11 --note that assignment has to precede COMMIT
12 COMMIT;
13 dbms_output.Put_line(i);
14END;