listagg拼接,返回的结果是varchar类型,而且有最大长度限制,可以转成clob或者截取
SELECT A.*,
A.C_JLBH C_RN,
B.C_QBDM,B.C_QBMC,B.D_KSSJ,B.D_JZSJ,
/*(SELECT f_link(T.C_BMLSH||',')
FROM T_QB_BZRXXTZ_MX T WHERE T.C_JLBH = A.C_JLBH) C_BMLSHSTR*/
/*(SELECT LISTAGG(T.C_BMLSH, ',') WITHIN GROUP( ORDER BY C_BMLSH)
FROM T_QB_BZRXXTZ_MX T WHERE T.C_JLBH = A.C_JLBH) C_BMLSHSTR*/
--解决 f_link、listagg “ 字符串连接的结果过长”的问题, listagg拼接,返回的结果是varchar类型,而且有最大长度限制,可以转成clob或者截取
(SELECT xmlagg(xmlparse(content T.C_BMLSH||',' wellformed) order by C_BMLSH).getclobval()
FROM T_QB_BZRXXTZ_MX T WHERE T.C_JLBH = A.C_JLBH) C_BMLSHSTR
FROM T_QB_BZRXXTZ A,T_QB_JH B
WHERE A.C_QBJHJLBH = B.C_JLBH