Re: Convert NUMBER to VARCHAR2

From: Steve A <spectre_at_hkstar.com>
Date: Thu, 25 Nov 1999 08:21:04 +0800
Message-ID: <1e1scic.13ab5rq12dvyfcN@[192.168.1.70]>

mystring:=to_char(my_numbercol)

where:
mynumbercol = the col of teh database
mystring = the variable you want it in.

steve

Tin Ngoc Doan <tndoan_at_abondigas.engr.ucdavis.edu> 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
Received on Wed Nov 24 1999 - 18:21:04 CST