Dear Members
in PL/SQL if i update any record then how do i know that how much rows have been updated by the Query.
Example
Declare
Cursor c is
(Select Empno, name, comm from emp);
Begin
for REC in c loop
update emp set comm = comm+100
where comm is not null
and empno = rec.empno;
end loop;
end;
This is just an example coding
From this update query not all the records will effect.
this will update those records whcih have commision.
so how do i count that how much REcords have been update.
Thanks
Count Effected Rows
Who is online
Users browsing this forum: No registered users and 7 guests