How do I turn off bind variable substitution in Sql Developer 3.2 when I am creating a trigger that references old and new values using the colon-old format?
I can use set define off for sqlplus, but that doesn't work for the bind variable substitution issue in triggers
You don't need to. Just use F5 to run the script. This works for me.
CREATE OR REPLACE TRIGGER TRIGGER1
BEFORE UPDATE ON DEPT
FOR EACH ROW
IF :old.dname = 'abc' THEN :new.dname := 'def'; END IF;