-- loop开始
--exit when saltotal > 50000;
fetch cemp into cempno,csal;
exit when cemp%notfound;
if (saltotal + csal * 0.1)<50000 then
saltotal := saltotal + csal*0.1;
update emp set sal = sal * 1.1 where empno = cempno;
count1 := count1 + 1;
else exit;
end if;
