SQLDeveloper – Tip- How to stop bind parameter substitution
SQLDeveloper raised bind parameter window, if it has ‘&’ value or ‘:’ value in the statement
![](http://oratrainings.com/wp-content/uploads/2020/12/image-7.png)
Use the below code to avoid bind variable substitution issue in SQLDeveloper
set define off;
![](http://oratrainings.com/wp-content/uploads/2020/12/image-8.png)
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;