Problem Solved: Inserting '&string' in SQL*Plus

Thank you for all of you!!!
Problem has been solved, and people are happy now!!! = )

"Dixon, Sidney (TQC)" wrote:

> set define off
>
> > ----------
> > From:
> > antonio.belloni_at_hstern.com.br[SMTP:antonio.belloni_at_hstern.com.br]
> > Sent: 14 November 2000 15:09
> > To: Keith Shum
> > Cc: Oracle Fatcity; Lazy DBA
> > Subject: Re: Inserting '&string' in SQL*Plus
> >
> >
> > Hi Keith,
> >
> > Try this:
> >
> > insert into table (column_name) values ('test '||chr(38)||' test');
> >
> > It will produce the string :
> >
> > 'test & test'.
> >
> > HIH,
> > Antonio Belloni
> > Oracle DBA
> >
> >
> >
> >
> > Keith Shum <kshum_at_iLux.com> on 13/11/2000 19:13:53
> >
> > To: Oracle Fatcity <oracle-l_at_fatcity.com>, Lazy DBA
> > <oracledba_at_quickdoc.co.uk>
> > cc:
> > Subject: Inserting '&string' in SQL*Plus
> >
> >
> > Hello, all,
> >
> > I have an interesting one on Monday... (I know, I know, we shouldn't
> > do anything of brain twisting today...)
> > While using SQL*Plus to INSERT a string with the special character
> > '&' like '&something' to a table, without using SET ESCAPE command, how
> > can we do it? Since the '&' is a reserved character for variable...
> > Thanks!
> >
> > --
> >
> > Keith Shum
> >
> > kshum_at_iLux.com
> >
> > iLux Corporation
> > Phone (510) 226-5600 x 643
> > Fax (510) 226-8182
> > Cellular Phone (510) 435-0286
> > 5600 Mowry School Road, Newark, CA 94560
> > http://www.iLux.com
> >
> >
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to
> > them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> >
> >
> >
> >
> >
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to
> > them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> >

--

Keith Shum

kshum_at_iLux.com

iLux Corporation
Phone (510) 226-5600 x 643
Fax (510) 226-8182
Cellular Phone (510) 435-0286