SQL>
SQL> create table t ( x int );
Table created.
SQL> declare
2 l_data dbms_sql.number_table;
3 l_empty dbms_sql.number_table;
4 begin
5 for i in 1 .. 1000
6 loop
7 l_data(mod(i,100)) := i;
8 if ( mod(i,100) = 0 )
9 then
10 forall j in 0 .. l_data.count-1
11 insert into t values ( l_data(j) );
12 l_data := l_empty;
13 end if;
14 end loop;
15 end;
16 /
PL/SQL procedure successfully completed.
SQL>
SQL> drop table t;
Table dropped.
SQL>