Re: SQL Updates utilizing Ampersands

In article <7uo9a3$sa2$1_at_nnrp1.deja.com>,   pberetta_at_my-deja.com wrote:
> 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';
>
>
This technique works, thanks!!
I also found another trick that works, though might be a little more dangerous to use.

1. Use the 'show all' command to find out what the '&' character is set to
2. Redefine the value. For example, the show all command reveals that define="&" We would type: set define="~" [or another character not being used]
3. Type in our update command as literal text
4. type: set define="&" [this puts things back in order]

2.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 15:46:38 CEST