Hi,
This is Rohit ,OCP from India.
Inside a pl/sql u can find out the number of rows processed by rowcount attribute of cursor.

eg.
declare
x number;
begin
insert into emp_dup
select * from emp;
select count(*) into x from emp_dup;
if sql%rowcount=x then
delete from emp;
end if;
end;

sql%rowcount attribute of cursor tells u how many rows have been processed.

If any doubts please be free to write to me at
[email protected]