select dbms_lob.substr(lo.ldtext) as text from longdescription lo
Oracle查询CLOB字段类型的内容
原文：https://www.cnblogs.com/xiaoliu66007/p/8391204.html
