loop
fetch emp_cursor into cempno,csal ;
exit when (totalSal + csal*0.1) > 50000 or emp_cursor%notfound;
update emp set sal=sal*1.1 where empno=cempno;
countsum:=countsum+1;
totalsal:=totalsal+csal*0.1;
end loop;
loop
exit when (totalSal + psal*0.1) > 50000;
fetch emp_cursor into cempno,csal ;
exit when emp_cursor%notfound;
update emp set sal=sal*1.1 where empno=cempno;
countsum:=countsum+1;
totalsal:=totalsal+csal*0.1;
end loop;
