How to convert CLOB to VARCHAR2 ?

dbms_lob.substr can help you.

Tips & Warnings

The dbms_lob.substr function has three parameters: the field name, the number of characters you want to convert and the position from which the conversion begins. The expression, dbms_lob.substr( clob_field, 4000, 1 ) converts 4,000 characters of clob field beginning with the first. Use a smaller number in place of 4,000 if you want to convert fewer characters, and use a number larger than one to shift the starting point of the conversion.