CREATE OR REPLACE PROCEDURE oracle_test as
BEGIN
DELETE FROM t WHERE id = 1;
dbms_output.put_line('DELETES:'||SQL%ROWCOUNT);
INSERT INTO t SELECT * FROM tt;
dbms_output.put_line('INSERTS:'||SQL%ROWCOUNT);
UPDATE t SET c=1;
dbms_output.put_line('UPDATES:'||SQL%ROWCOUNT);
END;
/