select * from PGENIUS.NEWS_CONTENT where dbms_lob.getlength(nvl(TXT_CONTENT,0))<4000
and dbms_lob.getlength(nvl(HTML_TXT,0))<4000 and GUID='0000000000000fsqnv'
--截取字符串
select substr(TXT_CONTENT,4000) from PGENIUS.NEWS_CONTENT
原文链接：https://www.f2er.com/oracle/213237.html