Re: UPDATE SET of multiple columns

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Thu, 13 Apr 2006 22:19:16 GMT
Message-ID: <IxoM06.MDr@igsrsparc2.er.usgs.gov>

> Thank you for your reply.
>
> I already have 6 update statements; but I would like to consolidate
> them into one to reduce the runtime of a job.

I like the solution proposed by Kenneth....very elegant!

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Thu Apr 13 2006 - 17:19:16 CDT