xmlagg解决listagg字符过长

LISTAGG( to_char(B.CLFA), '⚫') WITHIN GROUP(ORDER BY B.CLFA) AS CLFA

xmlagg(xmlparse(content '⚫'||B.CLFA wellformed) order by B.CLFA).getclobval() AS CLFA

SELECT
A.TSDH,
A.TSJBR,
xmlagg(xmlparse(content '⚫'||B.CLFA wellformed) order by B.CLFA).getclobval() AS CLFA
FROM
BO_LL_COMPLAINT_M A
INNER JOIN BO_LL_COMPLAINT_EM_S B ON A.BINDID = B.BINDID
GROUP BY
A.TSDH,
A.TSJBR