java接收到大数据类型是 数据库的oracle.sql.CLOB 时,,要在java代码里做转换,,
这很麻烦,,
所以,解决方法是:
在查出来的数据是直接转为字符就可以了to_char
SELECT to_char(wm_concat(COFFIELD)) COFFIELD,
to_char(wm_concat(coffieldname)) coffieldname
FROM
(SELECT coftablecode,
COFFIELD,
coffieldname,
showorder
FROM TM_SOURCETABLE_CONFIGITEM
WHERE coftablecode='TT_CRM'
AND isshow ='Y'
ORDER BY showorder
)
GROUP BY coftablecode