oracle将多个结果集用逗号拼接成字符串
1、使用 listagg
SELECT listagg(description
,',') within GROUP(ORDER BY description)
FROM sys_user
WHERE user_id = '2'
GROUP BY user_id
SELECT listagg(description
,',') within GROUP(ORDER BY description)
FROM sys_user
WHERE user_id = '2'
GROUP BY user_id