Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UPDATE SET of multiple columns

Re: UPDATE SET of multiple columns

From: DBA9999 <cdavis10717_at_comcast.net>
Date: 13 Apr 2006 12:00:54 -0700
Message-ID: <1144954854.342759.195390@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)
;
Received on Thu Apr 13 2006 - 14:00:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US