Re: SQL Updates utilizing Ampersands

Use SQL> set scan off

It will stop the search for the "&" substitution character.

Cliff

kaldi1_at_yahoo.com wrote:
>
> Hi:
>
> I am having problems while using sqlplus to update an oracle database.
>
> I would like to update a field with a value that has an ampersand in
> it, but I am receivig errors.
> My question is, is there an escape character that will wrap the
> ampersand so that it will be interpreted literally and if so, what is
> the syntax?
>
> Example
> update field_name from table_name set table_name='record_name &
> Johnson' where field_name='record_name';
>
> Every time I execute such a statement, I am prompted to enter the value
> for Johnson.
>
> TIA,
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.