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 -> update of a column

update of a column

From: boo <boo_at_yahoo.com>
Date: Fri, 15 Dec 2000 20:29:19 -0800
Message-ID: <3A3AEF9F.FC8F2352@yahoo.com> 






Running Oracle 8.0.5 on Solaris 2.6


We have a column called IP varchar2 (16) with data such as 198.1.2.30
and want to update all rows, changing the 198 to 192,
so the above example would then read 192.1.2.30.



Would someone offer a suggestion on the best approach to update this?
Received on Fri Dec 15 2000 - 22:29:19 CST












Original text of this message













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