-- Example of using sql%rowcount
declare
  vCnt  number:=0;
begin
  update employees set status = 'Hired' where name like '%WATSON';
  vCnt := vCnt+sql%rowcount;
end;
/