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 -> Is it possible to globally change a value in every column without doing an update on each one

Is it possible to globally change a value in every column without doing an update on each one

From: tony <ramdan_at_mailexcite.com>
Date: 9 Sep 1999 10:57:02 -0500
Message-ID: <oMQB3.3778$yd.149322@newscene.newscene.com> 





we have a table with 75 columns, a value of 999.9999 needs to be changed to 
999.9  regardless of  where it appears. Do we need to do an update on every 
single column or is it possible for one update column satement to do it?
Received on Thu Sep 09 1999 - 10:57:02 CDT












Original text of this message













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