LISTAGG函数:“字符串连接的结果太长“

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