Oracle数据库用触发器实现两张表数据同步

编写触发器实现两张表数据同步，sql代码如下：

create or replace trigger buid_mend_manager
    after insert or update or delete 
    on TMP_EIC_MEND
    referencing old as old_value
                new as new_value
    for each row
begin
    if inserting then
      insert into Eic_mend(mendid, mendname) 
      values(:new_value.mendid, :new_value.mendname);
    elsif updating then
      update Eic_mend set mendname = :new_value.mendname 
      where mendid = :new_value.mendid;
    elsif deleting then
      delete from Eic_mend where mendid = :old_value.mendid;
    end if;
end;

评论

1 楼 cn_arthurs 2009-09-15  

谢谢楼主啊,我找了好久啊
能在说下如何在在触发器中调用存储过程吗?