Welcome To Ask or Share your Answers For Others

oracle中sql如何写才能查询出超过5000个字的clob类型的字段？

asked Jan 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

数据库中的content字段是clob类型，里面存储这5000个汉字，
用dbms_lob.substr包裹的话也只能查询2000个字而已，如何写才能全部查询出来呢？
select dbms_lob.substr(content) as content from test_sw

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

3.6k views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Jan 24, 2021 by 深蓝 (71.8m points)

等待大神解答

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...