oracle中触发器将改变数据插入新表

来源:互联网 发布:电脑版淘宝会员登录 编辑:程序博客网 时间:2024/05/22 10:50
create or replace trigger xxx1
after update on table2
for each row
begin
  if(:old.xxx_date||'A'!=:new.xxx_date||'A') then
     insert into  table3(xxxx_id,xxxx_code,xxxx_time,xxxx_name,creator)
     values(xxxx_id_sequence.nextval,"xxxx",:new.xxx_date,:new.xxx_stopname,:new.creator);
  end if;
  if(:old.yyyy_date||'A'!=:new.yyyy_date||'A') then
     insert into  table3(xxxx_id,xxxx_code,xxxx_time,xxxx_name,creator)
     values(xxxx_id_sequence.nextval,"xxxx",:new.xxx_date,:new.xxx_stopname,:new.creator);
  end if;
  if(:old.zzzz||'A'!=:new.zzzz||'A') then
      insert into  table3(xxxx_id,xxxx_code,xxxx_time,xxxx_name,creator)
     values(xxxx_id_sequence.nextval,"xxxx",:new.xxx_date,:new.xxx_stopname,:new.creator);
  end if;
end xxx1;

0 0
原创粉丝点击