RE: How to suppress special characters in query

From: Oliver Jost <Oliver.Jost_at_ca.fujitsu.com>
Date: Tue, 6 Feb 2007 14:05:12 -0500
Message-ID: <DB508580748FAD4692628A58C4E653F5A355BE@MAIL01.Corp.FC.LOCAL>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 Received on Tue Feb 06 2007 - 13:05:12 CST