Re: UPDATE SET of multiple columns

You'll probably want multiple update statements.

update DISK_STATS_TBL
set DISKBSIZE_STAT = 0 where DISKBSIZE_STAT IS NULL;

update DISK_STATS_TBL
set DISKBUSY_STAT = 0 where DISKBUSY_STAT IS NULL;

update DISK_STATS_TBL
set DISKREAD_STAT = 0 where DISKREAD_STAT IS NULL;

etc.

HTH,
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