How to convert from long to varchar2?

[osman7king]

I have a column in a table with long datatype
and I want to convert all values in this column to varchar2 'no problem if the data been truncated on 4000 characters of length'.

may someone help me??

best regards..
osman

[debasisdas]

Better to use CLOB instead of using varchar data type.

[amitpatel66]

if that is custom table then not to use LONG data type and convert that to CLOB.

Check Ask Tom