Re: H.E.L.P w TRANSLATE function

I think you mean to use an UPDATE statement:

UPDATE customer
SET <date field> = 'AUGUST'
WHERE cust_code = '99078';

Fill in <date field> with the name of the column containing 'JULY'.

HTH Eric Raskin
eraskin_at_paslists.com

• Original Message ----- From: ZC <zuin_chn_at_my-deja.com> Newsgroups: comp.databases.oracle.tools Sent: Tuesday, December 14, 1999 12:25 PM Subject: H.E.L.P w TRANSLATE function

> If there is an existing record in a database, for example: JULY
> How would you chage it to AUGUST without having to delete the entire
> row.
>
> I'm trying this, but I'm not getting any luck. JUNE is in a column
> called month.
>
> Should i put COLUMN like this? TRANSLATE(column('AUGUST'
>
>
> SELECT TRANSLATE('AUGUST', 'ABCDEFGHIJKLMONOQRSTUVWXYZ'
> 'ABCDEFGHIJKLMONOQRSTUVWXYZ')
> from customer
> where cust_code = '99078';
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Dec 14 1999 - 18:52:03 CET