SQLDeveloper – Tip- How to stop bind parameter substitution

SQLDeveloper raised bind parameter window, if it has ‘&’ value or ‘:’ value in the statement

Use the below code to avoid bind variable substitution issue in SQLDeveloper

set define off;