老師講的超級(jí)棒!加油!希望慕課網(wǎng)有更多這種老師!
另外,慕課能不能開一個(gè)jbpm工作流的課程呀!
另外,慕課能不能開一個(gè)jbpm工作流的課程呀!
%rowcount不行,統(tǒng)計(jì)結(jié)果會(huì)比實(shí)際多出一條記錄。如果需要使用需%rowcount-1.
2016-04-08
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