ORACLE 某一列数据合并为字符串,用逗号分开
用 LISTAGG(字段,分隔符) WITHIN GROUP (ORDER BY 字段) 将列合并为字符串
SELECT DISTRICT_CODE from DISTRICT_TABLE

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

SELECT DISTRICT_CODE from DISTRICT_TABLE

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