取emp表中5个人的所有信息（用游标和for循环）

取emp表中5个人的所有信息

alter user scott account unlock;
alter user scott identified by tiger;
conn scott/tiger
SET serveroutput ON
DECLARE
  CURSOR emp_cursor IS SELECT empno,ename,job,mgr,hiredate,sal,comm,deptno FROM emp;
  TYPE my_table_type IS TABLE OF emp_cursor%ROWTYPE
                       INDEX BY BINARY_INTEGER;
  my_table  my_table_type;
  i number;
BEGIN
  OPEN emp_cursor;
   for i in 1..5 loop 
     FETCH emp_cursor INTO my_table(i);
   end loop;
  CLOSE emp_cursor;
  for i in 1..5 loop
  DBMS_OUTPUT.PUT_LINE(my_table(i).empno||'  '||my_table(i).ename||'  '||my_table(i).job||'  '||my_table(i).mgr||'  '||my_table(i).hiredate||'  '||my_table(i).sal||'  '||my_table(i).comm||'  '||my_table(i).deptno);
  end loop;
END;
/