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 - 04:59:17 CST
