Oracle 触发器记录

Oracle 触发器记录

CREATE OR REPLACE TRIGGER api_settlement_price_log
  AFTER update  on api_settlement_price --or insert 触发的方式
  for each row
--declare 声明
begin
  insert into emapiii.api_settlement_price_log
  values
    (
     :OLD.ID,
     :OLD.BRAND_CODE,
     :OLD.BRAND_NAME,
     :OLD.CONTRACT_CODE,
     :OLD.CONTRACT_NAME,
     :OLD.TYPE_NAME,
     :OLD.EAP_NAME,
     :OLD.BENEFIT_NAME,
     :OLD.PRICE,
     :OLD.CWCBP,
     :OLD.MAX_RESCUE,
     :NEW.UPDATE_USER,
     :NEW.UPDATE_TIME);
end;

//api_settlement_price为价格表，要求是每次有人改动价格都要去记录修改前的价格并记录操作人并将改动信息存进log表中