Oracle PLSQL Demo - 10.For Loop遍历游标[FOR LOOP CURSOR]

declare
    cursor cur_emp is
        select t.* from scott.emp t;

begin

     for r_emp in cur_emp loop
         
         dbms_output.put_line(r_emp.empno || '   ' || r_emp.sal);
     
     end loop;

end;

 

posted @ 2015-06-29 22:55  nick_huang  阅读(700)  评论(0编辑  收藏  举报