代碼段二：
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;
由于一次不能發(fā)表超過300個字，所以只能分散發(fā)布了：
代碼段一：
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;
