Output of CLOB

set long 32767;
select max(dbms_lob.getlength(e)) from d;

select dbms_lob.substr(MYCLOBCOL,4000,1) from TABLE

dbms_lob.substr(col_2,4000,1) col_2_1
,dbms_lob.substr(col_2,4000,4001) col_2_2
,dbms_lob.substr(col_2,4000,8001) col_2_3
from clob_table
/



select max(dbms_lob.getlength(e)) from d;