老师讲的超级棒!加油!希望慕课网有更多这种老师!
另外,慕课能不能开一个jbpm工作流的课程呀!
另外,慕课能不能开一个jbpm工作流的课程呀!
2016-04-30
loop
fetch cemp into pempno,psal;
exit when (salTotal +psal*0.1)>50000;
exit when cemp%notfound;
update emp1 set sal =sal*1.1 where empno=pempno;
countEmp :=countEmp+1;
salTotal := salTotal +psal*0.1;
end loop;
fetch cemp into pempno,psal;
exit when (salTotal +psal*0.1)>50000;
exit when cemp%notfound;
update emp1 set sal =sal*1.1 where empno=pempno;
countEmp :=countEmp+1;
salTotal := salTotal +psal*0.1;
end loop;
2016-04-08