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:
Followed by copying the content column using:Code:alter table id_table add content_new varchar2(4000)
However, i got the following error.Code:update id_table set content_new=content
Is there any way i can work around this? Thanks in advance!Code:ORA-00932: inconsistent datatypes: expected NUMBER got LONG