oracle 使用listagg函数后 字符串连接的结果过长最终解决
SELECT
r.department_id law_dept_id,
(
SELECT
xmlagg(xmlparse(content rt.extracted_person_ids||',' wellformed) order by rt.extracted_person_ids).getclobval()
FROM
RANDOM_TASK rt,
SYS_DEPARTMENT sd
WHERE
rt.CREAT_DEPARTMENT_ID = sd.DEPARTMENT_ID
AND sd.DEPARTMENT_NUMBER LIKE CONCAT (r.department_num, '%')
AND rt.distributed_state = 1
AND rt.STATE = 1
AND rt.LAUNCH_DATE BETWEEN TO_DATE ('2017-07-05', 'yyyy-mm-dd')
AND (TO_DATE('2017-07-05', 'yyyy-mm-dd') + 1)
) law_user_str
FROM
random_user_count r
ORDER BY
r.area_code,
r.department_num;
上述方法已通过验证。