Re: SQL Updates utilizing Ampersands

[Quoted] Try this,

update field_name from table_name set table_name='record_name ' || '&' || ' Johnson' where field_name='record_name';

I think it will do the trick. On the basis of this: SQL> update emp set ename = ename || ' ' || '&' || ' X'   2 where ename = 'KING';

1 row updated.

SQL> select ename from emp;

ENAME

Paul

In article <7unqli$hlm$1_at_nnrp1.deja.com>,   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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 01:57:56 CEST