CREATE OR REPLACE TRIGGER TRG_ZY_BRRY_UPDATE_ORACLE
AFTER UPDATE ON ZY_BRRY
FOR EACH ROW
BEGIN
IF :OLD.BRXM <> :NEW.BRXM or :OLD.BRXB <> :NEW.BRXB or :OLD.CSNY <> :NEW.CSNY THEN
update ys_zy_jzjl set brxm =:new.brxm,brxb = :new.brxb,csrq = :new.csny where jzhm = :new.zyh;
END IF;
END TRG_ZY_BRRY_UPDATE_ORACLE;
----------------
打算用她解决zy_brry 与ys_zy_jzjl问题
目标是更新掉zy_brry以后ys_zy_jzjl直接更新