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-----
From: Leslie Lu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 7:18 PM
To: Multiple recipients of list ORACLE-L
Subject: escape key ???
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
