最简单的游标循环 declare

declare
  cursor cur is
     select * from dept;
begin
     for v_emp in cur loop
       dbms_output.put('deptno='||v_emp.deptno);
       dbms_output.put(' dname='||v_emp.dname);
       dbms_output.put_line(' loc='||v_emp.loc);
     end loop;
end;