Re: Inserting '&string' in SQL*Plus

at the top of your script do:

SET DEFINE OFF don't forget to turn it back on when done.

Jared

On Mon, 13 Nov 2000, Keith Shum wrote:

> 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
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Mon Nov 13 2000 - 19:14:11 CST