RE: How to suppress special characters in query

Yes, set the escape character (sqlplus: options menu).
Or,  
sql> set escape \  

Will use back slash for the escape so you would run your sql as:
Select * from tab1 where col1 like = 'A \& B'

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh
Sent: Monday, February 05, 2007 1:03 PM
To: oracle-l
Subject: How to suppress special characters in query

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

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: