Re: Problem with ampreson(&)

Kjetil Skotheim wrote:
>
> Bhargav wrote:
> >
> > Hai,
> >
> > I want to insert some text with ampreson(&) value in a varchar2 field.
> > Please help me out.
> >
> > Bye,
> > Bhargav
>
> I guess you are using Sqlplus and when you try something like:
>
> insert into mytable values ('text&more');
>
> ...you're asked to fill in the &more part. This is because
> sqlplus interprets &... as sqlplus-variables. Solution:
>
> insert into mytable values ('text'||chr(38)||'more);
>
> --
> Kjetil Skotheim
> kjetilskotheim_at_iname.com

or just do

SQL> set define off

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy