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>