redolog生成指令碼

zhcunique發表於2021-03-04

create table test.t1 as select * from dba_objects;
declare
v_count integer;
begin
  v_count := 1;  
  for v_count in 1..100 loop
     insert into test.t1 select * from dba_objects;
     insert into test.t1 select * from dba_objects;   
     insert into test.t1 select * from dba_objects;   
     insert into test.t1 select * from dba_objects;
     insert into test.t1 select * from dba_objects; 
     commit;
     delete from test.t1;
   end loop;
end;
/  

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/69994536/viewspace-2761002/,如需轉載,請註明出處,否則將追究法律責任。

相關文章