RE: escape key ???

From: kkennedy <kkennedy_at_firstpoint.com>
Date: Tue, 16 Jul 2002 16:33:26 -0800
Message-ID: <F001.00499B1C.20020716163326@fatcity.com>

Hi Leslie,
Sounds like your problem is in SQLPlus where the & character is the prefix for substitution variables.

Look in the SQLPlus manual under SET DEFINE and SET ESCAPE.

You can choose a different character or you can turn off substitution with SET DEFINE OFF.

You can define an escape character with SET ESCAPE / (did you really mean to use a forward slash?). The default on my machine is SET ESCAPE OFF which is why your first attempt didn't work.

Kevin Kennedy
First Point Energy Corporation

-----Original Message-----
Sent: Tuesday, July 16, 2002 4: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: kkennedy
  INET: kkennedy_at_firstpoint.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 Tue Jul 16 2002 - 19:33:26 CDT