Re: inserting & into a table
From: Alan Mills <Alan.Mills_at_xservices.pants.fujitsu.com>
Date: Tue, 29 Jul 2003 10:43:58 +0100
Message-ID: <bg5fno$1iqu$1_at_news.icl.se>
Date: Tue, 29 Jul 2003 10:43:58 +0100
Message-ID: <bg5fno$1iqu$1_at_news.icl.se>
Presumably in SQL*Plus.
SET ESCAPE \ [Quoted] insert into table(col1) values ('Mani\&Anuj');
"Manikandan" <member12054_at_dbforums.com> wrote in message
news:3159506.1059463035_at_dbforums.com...
>
> Hi,
> I have to insert '&' value to my column.
> For ex.
> My insert statement will be
> insert into table(col1) values('Mani&Anuj');
> But the values 'Mani&Anuj' is populated at run time.
>
> Please guide me!
>
> --
> Posted via http://dbforums.com
Received on Tue Jul 29 2003 - 11:43:58 CEST