create or replace trigger tr_test before insert on table1 for each row begin insert into table2(field1,field2,field3,field4....)values(:new.field1,:new.field2,:new.field3,:new.field4.....) end tr_test;
create or replace trigger tr_test before insert on table1 for each row begin insert into table2(field1,field2,field3,field4....)values(:new.field1,:new.field2,:new.field3,:new.field4.....);//最好加上 commit; end tr_test;
before insert on table1
for each row
begin
insert into table2(field1,field2,field3,field4....)values(:new.field1,:new.field2,:new.field3,:new.field4.....)
end tr_test;
before insert on table1
for each row
begin
insert into table2(field1,field2,field3,field4....)values(:new.field1,:new.field2,:new.field3,:new.field4.....);//最好加上
commit;
end tr_test;
TKS
before insert on B
for each row
begin
insert into C values(:new.字段1,:new.字段2)
end AAA;