Hello Experts,
I would like to know the number of rows modified by an UPDATE DML in a table.
My source is an oracle collection.
Code:
set serveroutput on
declare
type t1 is table of emp%ROWTYPE;
tab1 t1;
cursor c1
is
select * from emp;
begin
open c1;
fetch c1 bulk collect into tab1;
forall i in tab1.FIRST..tab1.LAST
update emp
set sal = 100
where sal != tab1(i).sal;
close c1;
rollback;
end;
/
Could you please help me.
Thanks,
Haider