create or replace trigger trig_name
after insert or update or delete on invoice
for each row
begin
if INSERTING then
insert into tag(..) values(:new.id,'invoice',0);
elsif UPDATING then
insert into tag(..) values(:old.id,'invoice',1);<--更新的记录原来值
else
insert into tag(..) values(:old.id,'invoice',2);
end if;
end;
after insert or update or delete on invoice
for each row
begin
if INSERTING then
insert into tag(..) values(:new.id,'invoice',0);
elsif UPDATING then
insert into tag(..) values(:old.id,'invoice',1);<--更新的记录原来值
else
insert into tag(..) values(:old.id,'invoice',2);
end if;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货