Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Prevent "Enter Substitution Variable" from popping up

Wim BosJan 3 2017 — edited Jan 4 2017

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?

This post has been answered by thatJeffSmith-Oracle on Jan 3 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2017
Added on Jan 3 2017
2 comments
6,548 views