loop salTotal:=salTotal+psal*0.1; fetch cemp into pempno,psal; exit when cemp%notfound or salTotal>50000; update emp set sal=sal*1.1 where empno=pempno; countEmp:=countEmp+1; end loop; close cemp; commit; 这样可否呢?
可以吧