PL/SQL是一种程序语言,叫做过程化SQL语言(Procedural Language/SQL)。不是PL/SQL developer开发工具。
2017-02-09
/*这是循环里面的内容*/
exit when totalSal > 50000;
fetch cemp into pempno,psal;
exit when cemp%notfound;
exit when (totalSal + psal*0.1) > 50000;
totalSal := totalSal + psal*0.1;
countEmp := countEmp + 1;
/*温馨提示:因为后面还要用这张表,所以少对表进行操作,老师的步骤能做的来就好!*/
exit when totalSal > 50000;
fetch cemp into pempno,psal;
exit when cemp%notfound;
exit when (totalSal + psal*0.1) > 50000;
totalSal := totalSal + psal*0.1;
countEmp := countEmp + 1;
/*温馨提示:因为后面还要用这张表,所以少对表进行操作,老师的步骤能做的来就好!*/
2017-01-16
关于老师留下来的那个问题,第一个退出条件即视屏中的38行:exit when salTotal>50000,我改成了exit when salTotal + psal * 1.1>50000;把改后的这行放在视屏中40行fetch cemp into pempno,psal;后,不知道对不对?
2017-01-07