RE: How to suppress special characters in query

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Mon, 5 Feb 2007 16:07:18 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A9733456@usahm208.amer.corp.eds.com>

Place the SQLPlus statement

set define off

in the beginning of the script before any SQL or pl/sql

Mark D Powell -- Phone (313) 592-5148

-----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 4: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 Mon Feb 05 2007 - 15:07:18 CST