Re: help: many updates

On Sat, 22 Feb 2003 03:57:47 +0000, charlie cs wrote:

> 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.

The closest I can think of is the new 9i MERGE statement, which says 'if this record is found in table 1, update it so it matches the values in table 2. Otherwise, insert it into table 1 as a brand new record'.

Which isn't exactly what you want, because you appear to want to update table test's columns with some entirely NEW value if table 2 has a particular value.

But maybe there are ways you can adapt the syntax to do what you want.

Regards
HJR Received on Sat Feb 22 2003 - 21:41:40 CST