SQL>createtable t( xint, y char(50));
Table created.
SQL>
SQL>begin
2 for iin1 ..100000
3 loop
4 insertinto tvalues( i,'x');
5 endloop;
6 commit;
7 end;
8 /
PL/SQLprocedure successfully completed.
SQL>
SQL>selectcount(*)from t;
COUNT(*)
----------
100000
SQL>
SQL>droptable t;
Table dropped.
SQL>