Disable special character & in Oracle sql statement
If you issue
SQL> select '&1' from dual;
Enter value for 1: dummy
old 1: select '&1' from dual
new 1: select 'dummy' from dual
However, I would like to get:
instead of dummy, so disable the special charcter & in this sql statement.