help: many updates

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 Fri Feb 21 2003 - 21:57:47 CST