oracle将多个结果集用逗号拼接成字符串

1、使用 listagg

     SELECT listagg(description
                      ,',') within GROUP(ORDER BY description)
        FROM   sys_user
        WHERE  user_id = '2'
        GROUP  BY user_id
posted @ 2023-05-04 10:03  当个胖子  阅读(823)  评论(0编辑  收藏  举报