触发器

最新推荐文章于 2024-07-04 18:10:37 发布

iteye_16935

最新推荐文章于 2024-07-04 18:10:37 发布

阅读量79

点赞数

CC 4.0 BY-SA版权

文章标签： Oracle 触发器

本文链接：https://blog.youkuaiyun.com/iteye_16935/article/details/82484632

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