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

Re: Convert NUMBER to VARCHAR2

From: <murali09_at_my-deja.com>
Date: Wed, 24 Nov 1999 12:48:19 GMT
Message-ID: <81gmqj$mgc$1@nnrp1.deja.com>


You can

1. Export the data to a file
2. Delete all the rows from the table
3. Alter the NUMBER column to VARCHAR2
4. Import the data from the temporary file.

Regards,
K.Murali

In article <81g9j9$s4f$1_at_mark.ucdavis.edu>,   tndoan_at_abondigas.engr.ucdavis.edu (Tin Ngoc Doan) wrote:
> 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
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 24 1999 - 06:48:19 CST

Original text of this message

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