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

Home -> Community -> Usenet -> c.d.o.misc -> LONG DATATYPE

LONG DATATYPE

From: D S Tharpe <i5t_at_ornl.gov>
Date: Tue, 03 Nov 1998 11:05:39 -0500
Message-ID: <363F29D3.41C67EA6@ornl.gov> 





How can I take all the data from a table that has a field in it
defined as a long datatype and put it into a table that has the same
fields except for the long will now be going into a field that is 240
characters?




FROM TABLE



 field 1 varchar2(10)


 field 2 date


 field 3 long




TO TABLE



  field 1 varchar2(10)


  field 2 date


  field 3 varchar2(240)



TIA,


D. Tharpe
Received on Tue Nov 03 1998 - 10:05:39 CST












Original text of this message













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