Oracle-L: RE: escape key ???

From: Richard Huntley <rhuntley_at_mindleaders.com>
Date: Wed, 17 Jul 2002 02:23:22 -0800
Message-ID: <F001.00499D8E.20020717022322@fatcity.com>

Leslie, just do SET ESC ON (either at the SQL prompt or before the insert statement in the script if that's how you're doing it. The default is \. Then simply saying insert ... values ('a \& b'); will work.

-----Original Message-----
Sent: Tuesday, July 16, 2002 7:18 PM
To: Multiple recipients of list ORACLE-L

Hi all,

I need to insert some value with & as a part of the string.
For example, insert ... values ('a & b'); What escape key should be used?

insert ... values ('a /& b'); -- doesn't work insert ... values ('a '||'&'||' b'); -- works, but I'd like to know what escape key works in this case.

Thank you.

Leslie

Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Leslie Lu
INET: leslie_y_lu_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Richard Huntley
INET: rhuntley_at_mindleaders.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------