Re: sql*plus INSERT problem

Brad,

Try using the define command in sql*plus before the sql statement and resetting it back after.

Brad Stinson <bstinson_at_pinpoint.avl.com> wrote:
>
>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));
 define '$'
>insert into testtable values ('abcd&efg');
define '&'

>rather than inserting abcd&efg into field1, sql*plus gives
>me the prompt:
>
>Enter value for efg:
>
>How do I enter the & character in an insert statement????
>
>Brad
>bstinson_at_pinpoint.avl.com
>
Cheers,

Kevin Tomimatsu
Database Consultant
CIBER Consultants
Denver Co. Received on Mon Nov 13 1995 - 00:00:00 CET