Hi,

I'm trying to change one of the column in my table from LONG datatype to VARCHAR2 datatype.

I intend to create an new column using the SQL below:
Code:
alter table id_table add content_new varchar2(4000)
Followed by copying the content column using:
Code:
update id_table set content_new=content
However, i got the following error.
Code:
ORA-00932: inconsistent datatypes: expected NUMBER got LONG
Is there any way i can work around this? Thanks in advance!