BLOP to VARCHAR2

[cubi]

Hi,

Is there a way to convert a table column from BLOB to VARCHAR2 while keeping the data?

I inherit a database, and of the tables has four columns of type BLOB, but the data in them is just text. I want to turn those BLOB columns into VARCHAR2 but preserving the data.

Thank you.

 

[cubi]

Correction on my post. The datatype is CLOB, NOT BLOB. Sorry.

 

[sem]

You may use dbms_lob.substr function, but you should remember that varchar2 limit in Oracle is 4000 bytes only.