dbms_sql.number_table : DBMS_SQL « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. DBMS_SQL

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>