1、CLOB字段(内容较少)
直接用o_char
2、CLOB字段(内容较多,有规律,情况较少)
用DBMA_LOB.SUBSTR函数截取,然后拼接
select
b.wfss,
length(b.wfss) fcd,
case when length(b.wfss)>4000 then DBMA_LOB.SUBSTR(b.wfss,4000,1)||DBMA_LOB.SUBSTR(b.wfss,4000,4001)
else DBMA_LOB.SUBSTR(b.wfss,4000,1)
end fnr
from jc_swcljds b
//存在问题:会出现拼接长度过长的报错信息,可以拆开结果
select
b.wfss,
length(b.wfss) fcd,
DBMA_LOB.SUBSTR(b.wfss,4000,1) fcontent1,
DBMA_LOB.SUBSTR(b.wfss,4000,4001) fconttet2
from jc_swcljds b
//java后台用string拼接,excel需要适应公式生成
3、CLOB(内容长度不固定)
预定方案:还是用length判断,分情况拼接,但是无法适应动态的长度