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 -> Convert LONG Fields to Varchar2(4000)

Convert LONG Fields to Varchar2(4000)

From: A. Name <orakin_at_hotmail.com>
Date: 29 May 2002 04:50:40 -0700
Message-ID: <d1a2ec09.0205290350.7e8c47ed@posting.google.com> 





Hello all, 



I have a table in 7.3.4 that has a long field because the data was
just about 3500 characters long. Now we are upgrading to 8.1.7 and I
want to change all the long fields to varchar2(4000) and insert the
data. Can anyone tell me how to do this?



Thanks.
Received on Wed May 29 2002 - 06:50:40 CDT












Original text of this message













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