declare
   lt dbms_sql.varchar2_table;
begin
   execute immediate 'select name from emp where rownum <= 10'
      bulk collect into lt;
   --
   for i in lt.first .. lt.last
   loop
      dbms_output.put_line ('i=' || i || ', name = ' || lt(i));
   end loop;
end;