Re: Convert NUMBER to VARCHAR2

Sorry, maybe I was not clear on the issue.

I would like to change the column datatype in the table, not converting types during a select.

Thanks,
Tin

Screamer (mflopes_at_bigfoot.com) wrote:
: to_char(number_field)

: "Tin Ngoc Doan" <tndoan_at_abondigas.engr.ucdavis.edu> wrote in message
: news:81g9j9$s4f$1_at_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 - 05:35:19 CST