Register now and start sharing your code snippets.
-->
How to disable Oracle's variable name scanning
SQL posted 3 months ago by christian
Normally Oracle will scan SQL for variables and prompt for the value at runtime, to disable this feature use the “set scan off” command:
1 set scan off; 2 3 select * from links where href = 'http://...&....';