Free for PREMIUM members
Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium
CREATE OR REPLACE TRIGGER OWNER.TRG_UPD_MSG AFTER UPDATE ON OWNER.MYTABLE FOR EACH ROW
IF :OLD.MESSAGE <> :NEW.MESSAGE THEN
UPDATE OWNER.FKTABLE SET MESSAGE = :NEW.MESSAGE WHERE ID = :OLD.ID;
Open in new window
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!