2 Replies Latest reply on Jan 4, 2017 8:31 AM by Wim Bos

    Prevent "Enter Substitution Variable" from popping up

    Wim Bos

      When running a statement or compiling code that contains '&' (eg "SELECT '&Test' FROM DUAL;"), SQL developer always asks to enter a substitution variable ("Enter Substitution Variable" popup). Using Google I found that executing "SET DEFINE OFF;" upfront helps by disabling the substitution behavior, but it appears that this needs to be repeated for every worksheet you open.

       

      Any possibility to foresee a preference that allows auto-controlling substitution behavior (eg switch off by default)? Or is there any other known alternative that would prevent a lazy guy like me from having to re-execute the above described known workaround each time?