oracle-----list,array

定义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;