Question

oracle 数据库的触发器

oracle 数据库的触发器，在A表添加一条数据，然后将这条数据与B表关联查询到几条数据，添加到C表中怎么写？

Answer 1

create or replace trigger add_b_to_c
after insert on A
for each row
begin
if inserting then
insert into C(字段1,字段2,......) select 字段1,字段2,...... from B where <你的关联条件>
end if;
end;
/
这个就是对的呀

Answer 2

create or replace trigger add_b_to_c
after insert on A
for each row
begin
if inserting then
insert into C(字段1,字段2,......) select 字段1,字段2,...... from B where <你的关联条件>
end if;
end;
/

Answer 3

这样就可以了。
create or replace trigger tri_test
after insert on table_a
for each row
DECLARE
-- local variables here
BEGIN

INSERT INTO Table_c
SELECT Table_a.Col_1,
Table_b.Col_1
FROM Table_a,
Table_b
WHERE Table_a.Col_2 = Table_b.Col_2;

END Tri_Test;