I have a table and one of it's columns are "long" and I want to convert it to "varchar2" and maintain the data.

Help.

I've tried SELECT - INSERT INTO but got an error stating the illegal use of the LONG field.

Can someone give me an idea...I'm new to ORACLE.

Orakin