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 -> Convert NUMBER to VARCHAR2

Convert NUMBER to VARCHAR2

From: Tin Ngoc Doan <tndoan_at_abondigas.engr.ucdavis.edu>
Date: 24 Nov 1999 09:02:33 GMT
Message-ID: <81g9j9$s4f$1@mark.ucdavis.edu> 





Hi all,



Here is my situation.  I've a multi-column table with data, and one of 
the columns is a NUMBER type.  I need to convert it to VARCHAR2() type.



What is the best way to do this?



Unlike MySQL, Oracle does not handle all the copying in the background
using the ALTER TABLE command.  



Appreciate your help,


Tin 
Received on Wed Nov 24 1999 - 03:02:33 CST












Original text of this message













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