Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: escape key ???

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
--------------------------------------------------------------------
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). Received on Wed Jul 17 2002 - 05:23:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US