關(guān)于授之于漁的問題
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; 這樣可否呢?
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; 這樣可否呢?
舉報(bào)
2016-06-10
?可以吧