RE: Inserting '&string' in SQL*Plus

The scan works fine, but to cover most special characters, chr(x)|| works great.

-----Original Message-----

From:	Vladimir Begun [SMTP:jester_at_sunbay.com]
Sent:	Tuesday, November 14, 2000 10:47 AM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: Inserting '&string' in SQL*Plus

> Hello, all,
>
> I have an interesting one on Monday... (I know, I know, we shouldn't
> do anything of brain twisting today...)
> While using SQL*Plus to INSERT a string with the special character
> '&' like '&something' to a table, without using SET ESCAPE command, how

set scan off

-- 
Vladimir Begun            | Just don't compare it with a real language, or
                          | you'll be unhappy...  :-)
                          |          -- Larry Wall in
                          |          <1992May12.190238.5667_at_netlabs.com>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vladimir Begun
  INET: jester_at_sunbay.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).