SQL>
SQL> create table t ( x int );
Table created.
SQL>
SQL> alter session set sql_trace=true;
Session altered.
SQL>
SQL> begin
2 for i in 1 .. 1000
3 loop
4 execute immediate 'insert into t values ( ' || i || ')';
5 end loop;
6 end;
7 /
PL/SQL procedure successfully completed.
SQL>
SQL> drop table t;
Table dropped.
SQL>
|