How to suppress special characters in query
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Feb 2007 16:02:46 -0500
Hi,
We have a query like following that includes the & symbol and since this
is a special character so Oracle prompts for the input. Is there any way
to suppress this special character in a query without using the set
define off option at sqlplus session?
Select * from tab1 where col1 like = 'A & B'
Thanks
--Harvinder
--
//www.freelists.org/webpage/oracle-l
Other related posts:
