title: Set define off not working in Oracle SQL Developer
body: <p>I'm using SQL developer connected to an Oracle database, and I'm trying to create a trigger that looks something like below:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER my_trigger BEFORE
   UPDATE ON ZONE FOR EACH ROW BEGIN :new.LAST_UPDATED_DTTM := SYSTIMESTAMP ;
   END;
  /
  </code></pre>
  
  <p>The problem I'm having is that the ":new" causes SQL developer to prompt for the value of the variable "new" (to try to bind the variable). </p>
  
  <p>I tried using:</p>
  
  <pre><code>set define off;
  </code></pre>
  
  <p>It executes successfully, but I'm still prompted to enter a value for the variable.</p>
  
  <p>Any idea what to do? </p>