This content has been marked as final. Show 2 replies
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?