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;