场景:
当商户修改入驻信息的时候,会在入驻修改表中插入一条修改后信息。
表结构为:
触发器:
思路:判断表中新值和旧值是否是相等,如果不一样就记录下来,最后统一插入入驻修改表中。
CREATE OR REPLACE TRIGGER PM_ENTER_RECORD_TRIGGIR
BEFORE
UPDATE OF "CONTRACT_NO","CUSTOMER_NM","ENTER_PLACE","ENTER_STS","WATER_METER_NUM",
"GAS_METER_NUM","ELECTRIC_METER_NUM","REMARK" ON PM_ENTER_RECORD FOR EACH ROW
declare
/*修改数据项*/
alterColmun varchar2(200);
/*原值*/
originalValue varchar2(200);
/*修改值*/
alterValue varchar2(200);
BEGIN
if :OLD.CONTRACT_NO <> :NEW.CONTRACT_NO then
/*合同编号*/
alterColmun := '合同编号&