CREATE OR REPLACE TRIGGER TR_UPDATEJGH
AFTER UPDATE ON Jg_Jbxx--当修改了TABLE2时触发
FOR EACH ROW
BEGIN
CASE
WHEN UPDATING('Jgh') THEN
UPDATE Jg_Dqsj SET jgh=:NEW.jgh WHERE jgh=:OLD.jgh;
UPDATE Jg_Cc SET jgh=:NEW.jgh WHERE jgh=:OLD.jgh;
END CASE;
END;
CREATE OR REPLACE TRIGGER TR_UPDATEDelete
AFTER UPDATE ON Jg_Jbxx--当修改了TABLE2时触发
FOR EACH ROW
when (new.DEL_FLAG='1')--当tabel2的DEL_FLAG值为1时触发操作
BEGIN
CASE
WHEN UPDATING('DEL_FLAG') THEN
UPDATE Jg_Dqsj SET DEL_FLAG=:NEW.DEL_FLAG WHERE jgh=:OLD.jgh;
UPDATE Jg_Cc SET DEL_FLAG=:NEW.DEL_FLAG WHERE jgh=:OLD.jgh;
END CASE;
END;
AFTER UPDATE ON Jg_Jbxx--当修改了TABLE2时触发
FOR EACH ROW
BEGIN
CASE
WHEN UPDATING('Jgh') THEN
UPDATE Jg_Dqsj SET jgh=:NEW.jgh WHERE jgh=:OLD.jgh;
UPDATE Jg_Cc SET jgh=:NEW.jgh WHERE jgh=:OLD.jgh;
END CASE;
END;
CREATE OR REPLACE TRIGGER TR_UPDATEDelete
AFTER UPDATE ON Jg_Jbxx--当修改了TABLE2时触发
FOR EACH ROW
when (new.DEL_FLAG='1')--当tabel2的DEL_FLAG值为1时触发操作
BEGIN
CASE
WHEN UPDATING('DEL_FLAG') THEN
UPDATE Jg_Dqsj SET DEL_FLAG=:NEW.DEL_FLAG WHERE jgh=:OLD.jgh;
UPDATE Jg_Cc SET DEL_FLAG=:NEW.DEL_FLAG WHERE jgh=:OLD.jgh;
END CASE;
END;