oracle 表部类 表变量

oracle 表类型 表变量
declare
  type my_emp is table of scott.emp%rowtype index by binary_integer;
  new_emp my_emp;
  v_num   number := 0;
  cursor cur_emp is
    select empno, ename, job, sal from scott.emp;
begin
  /*  for v_emp in cur_emp loop
    v_num := v_num + 1;
    select * into new_emp(v_num) from scott.emp where ename = v_emp.ename;
  end loop;*/

  select * bulk collect into new_emp from scott.emp;

  for i in 1 .. new_emp.count loop
    dbms_output.put_line(new_emp(i)
                         .empno || ',' || new_emp(i).ename || ',' || new_emp(i).job || ',' || new_emp(i).sal);
  end loop;
end;