首先，老师讲的非常好，满满的干货，赞！学这个课程之前需要有一定的oracle基础知识（语法，分组函数，高级查询），才能很好的吸收。本人是有了基础知识和开发经验之后再听这个课，接收快，一天看完此课程。
2016-10-22
LOOP
FETCH cemp INTO pnum,psal;
EXIT
WHEN (money +psal*0.1>50000)OR cemp%notfound;
UPDATE emp SET sal=psal*1.1 WHERE empno=pnum;
money :=money+psal*0.1;
num1 := num1+1;
END LOOP;
FETCH cemp INTO pnum,psal;
EXIT
WHEN (money +psal*0.1>50000)OR cemp%notfound;
UPDATE emp SET sal=psal*1.1 WHERE empno=pnum;
money :=money+psal*0.1;
num1 := num1+1;
END LOOP;
2016-10-10
