代码段二：
loop
exit when totalsal>50000;
fetch emp_cursor into cempno,csal ;
exit when emp_cursor%notfound;
if totalsal+csal*0.1<=50000 then --这一句很关键，如果没有这个判断的话，总工资可能会超过5万。
update emp set sal=sal*1.1 where empno=cempno;
countsum:=countsum+1;
totalsal:=totalsal+csal*0.1;
end if;
end loop;
commit;
由于一次不能发表超过300个字，所以只能分散发布了：
代码段一：
set serveroutput on;
declare
cursor emp_cursor is
select empno,sal from emp order by sal asc;
countsum number :=0;
totalsal emp.sal%type;
cempno emp.empno%type;
csal emp.sal%type;
begin
select sum(sal) into totalsal from emp;
open emp_cursor;
