Today, I tried to execute a simple query like :
select '&ab' from dual;
as expected I was prompted to insert value for ab...
So, to query special character & you have several options :
- change DEFINE settings to allow &;
- define a escape character;
- don't scan for substitution variables;
set define off;
select '&ab' from dual;
set escape '\';
select '\&ab' from dual;
set scan off;
select '\&ab' from dual;
No comments:
Post a Comment