what is the Alternate for AMPERSAND (&) in oracle???????????
Hi All,
This is my query......
select * from
(
select 'abc' a from dual union
select 'def' a from dual union
select 'abc & xyz' a from dual
) where a='abc & xyz';
Output should be 'abc & xyz'.
Since I am using '&' it will prompt to enter some value from my keyboard.
Yes, I know, I will get the output either by using set scan off,set define off, set escape on.
what is the Alternate for AMPERSAND (&) in oracle???????????
The value 'abc & xyz' will be passed from the front end and will be passed to the select statement..........
Regards,
Kashyap Varma N