老師講的超級棒!加油!希望慕課網(wǎng)有更多這種老師!
另外,慕課能不能開一個(gè)jbpm工作流的課程呀!
另外,慕課能不能開一個(gè)jbpm工作流的課程呀!
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