oracle游标

create or replace procedure test_pro
as
dept_record dept%rowtype;
cursor dept_cursor is select * from dept;
begin
 for dept_record in dept_cursor loop
           dbms_output.put_line(dept_record.dname);
end loop;
end test_pro;