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;
Oracle PLSQL Demo - 10.For Loop遍历游标[FOR LOOP CURSOR]
原文：http://www.cnblogs.com/nick-huang/p/4609075.html