ORACLE 某一列数据合并为字符串,用逗号分开

用 LISTAGG(字段,分隔符) WITHIN GROUP (ORDER BY 字段) 将列合并为字符串

SELECT DISTRICT_CODE from DISTRICT_TABLE
image

SELECT LISTAGG ( DISTRICT_CODE, ',' ) WITHIN GROUP ( ORDER BY DISTRICT_CODE ) AS DISTRICT_CODE from DISTRICT_TABLE
image

posted @ 2021-07-22 14:17  Yolo15  阅读(676)  评论(0)    收藏  举报