你知道你所说的对应2条数据是什么意思, create or replace procedure update_test as begin for i in 6 .. 100000 loop insert into testone values (i); end loop; commit; end;create or replace trigger before_tri before insert on testone for each row begin insert into testtwo (id,fk_id) values(:new.id,:new.id); end before_tri;
begin for i in 1.. xxxx loop insert into test1 select * from a where rownum<10; insert into test2 select * from b where rownum<20; end loop; end; / 大概是个意思,一个比一个多一倍 不就ok了
可以参考下
create or replace procedure update_test as
begin
for i in 6 .. 100000 loop
insert into testone values (i);
end loop;
commit;
end;create or replace trigger before_tri before insert on testone
for each row
begin
insert into testtwo (id,fk_id) values(:new.id,:new.id);
end before_tri;
for i in 1.. xxxx loop
insert into test1 select * from a where rownum<10;
insert into test2 select * from b where rownum<20;
end loop;
end;
/
大概是个意思,一个比一个多一倍 不就ok了