Re: inserting records

From: diversif <diversif_at_ix.netcom.com>
Date: 1997/02/11
Message-ID: <01bc1827$708e5ae0$4e98b8cd@PHUBER>#1/1

The & character is the default 'Define' value. (Similar to the $ in Unix). You have to 'set define' to something else, or 'off' (i.e set define off - OR - set define ~)

Motley Crue, Vaxxer <chuacl_at_iscs.nus.sg> wrote in article <5dombj$54s_at_nuscc.nus.sg>...
> When I tried to insert a record contains a '&' character into a varchar2
> datatype column, it will prompt me for the value of string that appears
after
> the & char, eg record is "t & t1"
>
> After I entered the insert sql statement, I'll get the following
> Enter value for t1:
> #after I pressed enter
> old : insert ....... values("t & t1")
> new : insert ....... values("t & ")
>
>
> Tried to put to a backslash in front of the & char as an escape char but
it
> doesn't seemed to work. Anyone has any idea why is this happening and how
can
> I go abt to insert the & char into the table? TIA.
>
> --
> Choon Leong
>
Received on Tue Feb 11 1997 - 00:00:00 CST