[code]
定义
type idList_type is table of emp.id%type;
type namelist_type is table of emp.name%type;
idlist idlist_type;
namelist namelist_type;
begin
open emp_cv for select id,name from emp;
fetch emp_cv bulk collect into idlist,namelist; //这个语句一次性就放入了
close emp_cv;
for i in idlist.first .. idlist.last loop
dbms_output.put_line(idlist(i));
end loop;
end;
[/code]
定义
type idList_type is table of emp.id%type;
type namelist_type is table of emp.name%type;
idlist idlist_type;
namelist namelist_type;
begin
open emp_cv for select id,name from emp;
fetch emp_cv bulk collect into idlist,namelist; //这个语句一次性就放入了
close emp_cv;
for i in idlist.first .. idlist.last loop
dbms_output.put_line(idlist(i));
end loop;
end;
[/code]