loop
fetch sals into csal,cempno;
select sum(sal) into saltotal from emp;
exit when sals%notfound or saltotal*1.1>=50000;
saltotal:=saltotal*1.1;
ccount:=ccount+1;
update emp set sal=sal*1.1 where empno=cempno;
end loop;
close sals;
loop
fetch cs into pempno,psal;
exit when salTotal>50000 or cs%notfound;
if (salTotal + psal*0.1)>50000 then exit;
else
update emp set sal =sal *1.1 where empno=pempno;
countEmp :=countEmp+1;
salTotal :=salTotal + psal*0.1;
end if;
end loop;
