Oracle 触发器数据同步

创建触发器的一般语法是:

CREATE [OR REPLACE] TRIGGER trigger_name
{BEFORE | AFTER }
{INSERT | DELETE | UPDATE [OF column [, column …]]}
[OR {INSERT | DELETE | UPDATE [OF column [, column …]]}...]
ON [schema.]table_name | [schema.]view_name 
[REFERENCING {OLD [AS] old | NEW [AS] new| PARENT as parent}]
[FOR EACH ROW ]
[WHEN condition]
PL/SQL_BLOCK | CALL procedure_name;

代码实例：

CREATE OR REPLACE TRIGGER DEPARTTRIGGER
AFTER INSERT OR UPDATE OR DELETE ON sxxjpd.stb_depart FOR EACH ROW
BEGIN
  CASE
    WHEN inserting THEN
         insert into sxsla.STB_DEPART (DEPART_CODE, DEPART_NM, DEPART_FCODE, DEPART_ISLEAF, CORP_CODE, DEPART_STATUS, DEPART_ATTR, DEPART_ID)
         values (:NEW.DEPART_CODE, :NEW.DEPART_NM, :NEW.DEPART_FCODE, :NEW.DEPART_ISLEAF, :NEW.CORP_CODE, :NEW.DEPART_STATUS, :NEW.DEPART_ATTR, :NEW.DEPART_ID);  
    WHEN updating THEN
      update sxsla.stb_depart set DEPART_CODE=:NEW.DEPART_CODE, DEPART_NM=:NEW.DEPART_NM, DEPART_FCODE=:NEW.DEPART_FCODE, DEPART_ISLEAF=:NEW.DEPART_ISLEAF, CORP_CODE=:NEW.CORP_CODE, DEPART_STATUS=:NEW.DEPART_STATUS, DEPART_ATTR=:NEW.DEPART_ATTR where  DEPART_ID=:OLD.DEPART_ID;
    WHEN deleting THEN
      delete from sxsla.stb_depart where DEPART_ID=:OLD.DEPART_ID;
  END CASE;
END;