create or replace trigger autoUpdate after insert into 表1 for each row declare begin for i in 1..10 loop insert 表2 end loop; exception when others then rollback; end;
就通过事务实现就可以了啊插入表1 If error then rollbackfor (i = 1 ; i <= 10 ; i ++) { 插入表2 If error then rollback }commit
create or replace trigger autoUpdate
after insert into 表1
for each row
declare
begin
for i in 1..10 loop
insert 表2
end loop;
exception
when others then
rollback;
end;
If error then rollbackfor (i = 1 ; i <= 10 ; i ++)
{
插入表2
If error then rollback
}commit