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;