触发器

create or replace trigger BACKUP_SUB_TRIGGER
  before delete on tb_om_subs  
  for each row
declare

  -- local variables here
begin
 
  INSERT INTO TB_OM_SUBS_HIST(
        ID,
        SUBS_CODE,
        MEMBER_ID,
        MER_GROUP_ID,
        MER_ID,
        TOTLE_BILL,
        GET_DATE,
        DELAY_TIME,
        SUBS_STATUS,
        CARD_TYPE,
        PAY_WAY,
        CUST_COMMENTS,
        CREATE_DATE,
        MOD_DATE,
        GET_WAY
  )VALUES(
        SQ_SUBS_HIST_ID.NEXTVAL,
        :OLD.SUBS_CODE,
        :OLD.MEMBER_ID,
        :OLD.MER_GROUP_ID,
        :OLD.MER_ID,
        :OLD.TOTLE_BILL,
        :OLD.GET_DATE,
        :OLD.DELAY_TIME,
        :OLD.SUBS_STATUS,
        :OLD.CARD_TYPE,
        :OLD.PAY_WAY,
        :OLD.CUST_COMMENTS,
        :OLD.CREATE_DATE,
        :OLD.MOD_DATE,
        :OLD.GET_WAY
  );
end BACKUP_SUB_TRIGGER;

tb_om_subs：要删除数据的表
before：删除操作之前触发
TB_OM_SUBS_HIST：用于备份数据的表，表结构与tb_om_subs一样
SQ_SUBS_HIST_ID：TB_OM_SUBS_HIST的序列
old：insert、update、delete之前的值
new：insert、update 要插入或改变的值
触发器中不能commit

转自：http://blog.sina.com.cn/s/blog_5969fc560100tir5.html