Oracle : Converting clobs to varchar2 01 December 2005 at 00:00
Clob to VARCHAR2

The easiest way is to use the dbms_lob package (desc the package to view all functions) e.g.:

  dbms_lob.substr(your_column, 255)

You could also use the getlength() function in the package if you need to retrieve the entire value of the clob (limited to the maximum length of VARCHAR2 which is 32767).