Re: UPDATE SET of multiple columns

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 13 Apr 2006 15:06:42 -0400
Message-ID: <KcydnY0KJb3bPKPZ4p2dnA@comcast.com>

"DBA9999" <cdavis10717_at_comcast.net> wrote in message news:1144954854.342759.195390_at_u72g2000cwu.googlegroups.com...
: OK, but something like this doesnt work either, right:
:
: update table
: set col1 = (select 0 from dual where col1 is null),
: col2 = (select 0 from dual where col2 is null),
: col3 = (select 0 from dual where col3 is null)
: ;
:

why do you think it would? not really being sarcastic... the point is you really need to think through the expected results not just through syntax at the problem.

++ mcs Received on Thu Apr 13 2006 - 14:06:42 CDT