转自:https://blog.csdn.net/snowfoxmonitor/article/details/50086811点击打开链接
SQL>createtable t( xint, y char(50));
Table created.
SQL>
SQL>begin
2 for i in ..100000
3 loop
4 insert to t values( 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>