Re: sql*plus INSERT problem

In article <NEWTNews.816043152.13898.bstinson_at_bns.avl.com> Brad Stinson <bstinson_at_pinpoint.avl.com> writes:

> If I attempt to insert values into a VARCHAR2 field that contain
> the '&' character, sql*plus prompts me for the value of the
> argument specified by the string following the '&' character.
> Here is the scenario:
>
> create table testtable (field1 varchar2(50));
> insert into testtable values ('abcd&efg');
>
> rather than inserting abcd&efg into field1, sql*plus gives
> me the prompt:
>
> Enter value for efg:

Use SET SCAN OFF.

I've read six answers to your question and only one has mentioned (without naming) this solution. Curious.

Chris

-- 
Christopher Jones, cjones_at_au.oracle.com