How to view CLOB data in Oracle SQL developer

 

Use dbms_lob.substr package to view CLOB field data in sql developer.

Eg :

SELECT dbms_lob.substr( DESCRLONG, dbms_lob.getlength(DESCRLONG), 1) FROM PSMSGCATDEFN