SQL> set serveroutput off
SQL> begin
2 for idx in 1..100000
3 loop
4 dbms_output.put_line('This is a long line of text') ;
5 end loop ;
6 end ;
7 /
PL/SQL procedure successfully completed.
SQL> set serveroutput on size 2000
SQL> begin
2 for idx in 1..100000
3 loop
4 dbms_output.put_line('This is a long line of text') ;
5 end loop ;
6 end ;
7 /
SQL> begin
2 for idx in 1..100000
3 loop
4 dbms_output.put_line('This is a long line of text') ;
5 end loop ;
6 end ;
7 /
PL/SQL procedure successfully completed.
SQL> set serveroutput on size 2000
SQL> begin
2 for idx in 1..100000
3 loop
4 dbms_output.put_line('This is a long line of text') ;
5 end loop ;
6 end ;
7 /
to zealot_zk(风中追风) :批量插入完后,一次性提交,可能是回滚段的问题,我如何设置呢?
to sunnyshine(光光):你意思是什么呢?
谢谢大家的参与!!!!
set serveroutput off
set serveroutput off