dbms_lob.substr character string buffer too small


oracle查询数据的时候clob类型不显示,如果数据长度超过4000将无法正常查询,可以使用下面的方法:

select dbms_lob.substr(column,4000,1) part1,
dbms_lob.substr(column,4000,4001) part2 from .....

参考链接:https://stackoverflow.com/questions/3790379/how-to-query-a-clob-column-in-oracle


Whatever is worth doing is worth doing well.