Question

oracle触发器insert时触发数据插入另一个表中

oracle触发器怎么写啊？插入a表时时触发把数据插入到b表中

Answer 1

CREATE OR REPLACE TRIGGER 触发器名称 AFTER INSERT ON a FOR EACH ROWBEGIN INSERT INTO b VALUES(:new.字段, :new.字段......);END;

Answer 2

create or replace trigger trg_a after insert
ON a
for each row
begin
INSERT INTO b values(:NEW.ID,:NEW.NAME);
end;

Answer 3

create trigger tri after insert on afor statementbegininsert into b select * from a;end;这个前提是a表与b表的结构一致

Answer 4

CREATE OR REPLACE TRIGGER TRG_aI AFTER
INSERT ON a FOR EACH ROW
BEGIN INSERT INTO b(x,x)VALUES(x,x)end;