This script demonstrates how to do a non-bulk select into elements of a PL/SQL table.
SQL> CREATE TABLE myTable 2 (id INTEGER NOT NULL 3 ,CONSTRAINT id_pk PRIMARY KEY (id)); Table created. SQL> SQL> SQL> SQL> SQL> SQL> DECLARE 2 3 4 TYPE number_table IS TABLE OF myTable.id%TYPE INDEX BY BINARY_INTEGER; 5 6 7 number_list NUMBER_TABLE; 8 9 BEGIN 10 11 12 FOR i IN 1..10000 LOOP 13 INSERT INTO myTable VALUES (i); 14 END LOOP; 15 16 END; 17 / PL/SQL procedure successfully completed. SQL> SQL> SQL> SQL> drop table myTable; Table dropped. SQL> SQL> SQL>