Wednesday, August 31, 2016

How to get big size clob content from table

select column1,DBMS_LOB.SUBSTR(clobColumn,4000,1) as clobColumn 
               from table

No comments:

Post a Comment