create or replace trigger trigger_name after insert on table_a for each row
begin
insert into table_b values (:new.id,:new.C_id);
commit;
end;
begin
insert into table_b values (:new.id,:new.C_id);
commit;
end;
同样,B表也该有个同样的触发器。