Re: parameter substitution in SQL*PLUS

Use ESCAPE.
ex. update table1 set field1 = 'long & lean' where record_id = nn

        ESCAPE '&'; Eric Fang

mdavies_at_elekom.com wrote in article <872557427.318_at_dejanews.com>...
> I would like to execute an update statement as follows:
>
> update table1 set field1 = 'long & lean' where record_id = nn;
>
> where the literal string 'long & lean' contains the ampersand character
> (&) as a literal character. While there is nothing in SQL to dissallow
> this, the SQL*PLUS window environment keys on this character as a
> parameter substitution character and prompts me to enter a value.
>
> If I have this update statement in a script in a file, how can I escape
> the "&" character when submitting the script to the database thru
> SQL*PLUS?
>
> Thanks in advance for anyone's help on this.
>
> mdavies_at_elekom.com
> ELEKOM Corp. a developer of business to business commerce software.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
  Received on Tue Aug 26 1997 - 00:00:00 CDT