Re: help: many updates

"charlie cs" <cs3526(no-spam)@yahoo.com> 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';
> .....

Inference is not very effective in this situation. I have know idea what general principle your example is supposed to be demonstrating.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB