用sql的多表插入或者触发器都可以的首先用 sql insert first or insert all insert all or first when condition then into table_nameA when conditon then into table_nameB select * from table_namesrc;用触发器 creat or replace trigger tr_test before or after insert on table_namesrc for each row declare --申明变量 begin insert into table_nameA(:new.id,:new.name); insert into table_nameB(:new.id,:new.name); end;
insert first or insert all
insert all or first
when condition then into table_nameA
when conditon then into table_nameB
select * from table_namesrc;用触发器
creat or replace trigger tr_test
before or after insert on table_namesrc
for each row
declare
--申明变量
begin
insert into table_nameA(:new.id,:new.name);
insert into table_nameB(:new.id,:new.name);
end;