Re: help: many updates

Hi,

Could you explain exactly what you want to do ? You work with just one table "TEST" or with more than one table ?

If it's just one table, you can't do the update with just one sql, beacause the where clause is not the same.

Dias

"charlie cs" <cs3526(no-spam)@yahoo.com> wrote in message news:<%yC5a.4661$_J5.1250_at_nwrddc01.gnilink.net>...
> We are using 9.2.
> We need to update a big table like this
>
> SQL> update table test set colA='A' where colA_1='X';
> SQL> update table test set colB='B' where colB_1='Y';
> SQL> update table test set colC='C' where colC_1='Z';
>
> .....
>
> Is there any way we can do this in one sql, instead of making several
> database calls?
>
> Thanks for you help.
Received on Sun Feb 23 2003 - 02:19:05 CST