Re: INSERTing string containing character '&'

This behavior can be suppressed by either define escape = <some other character>
or
set scan off
which will disable the feature completely. Show all
will provide you with an overview of all these settings.

Hth,

Sybrand Bakker, Oracle DBA

Howard Lee Harkness wrote in message <7hkq9f$kfv$1_at_nnrp1.deja.com>...
>I have a table defined as:
>CREATE TABLE NAMES
>(
>MFGCODE VARCHAR2(5),
>MFGNAME VARCHAR2(40)
>);
>
>I tried to do an insert similar to the following:
>
>INSERT INTO NAMES
>( '00001', 'Bartles&James' );
>
>and SQL*Plus responded with:
>
>Enter value for James:
>
>Which is a good indicator that the '&' is some sort of special
>character, presumably used for passing parameters interactively. So
>how do I defeat the special nature of this character? Are there other
>characters I need to defeat? I have about 7 Mb of names in a file to
>import, many of which contain '&' in the name.
>
>--
>Replies send to this email address are automatically discarded. To
>reply, please post in this newsgroup, or send to harkness at skeptics
>dot org. Thank-you.
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Sat May 15 1999 - 22:14:41 CDT