汇总数据库培训-PLSQL.pptVIP

* 游标变量/动态游标 select语句是动态的 declare --定义一个类型(ref cursor)弱类型 type cur is ref cursor; --定义一个ref cursor类型的变量 cura cur; c1rec emp%rowtype; c2rec dept%rowtype; begin DBMS_output.put_line(输出员工) ; open cura for select * from emp; loop fetch cura into c1rec; exit when cura%notfound; DBMS_output.put_line(c1rec.ename) ; end loop ; DBMS_output.put_line(输出部门) ; open cura for select * from dept; loop fetch cura into c2rec; exit when cura%notfoun