Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.6k views
in Technique[技术] by (71.8m points)

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

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...