oracle语句中如何把一列的值合并为一个值，用逗号隔开

数据库技术学习 https://www.itkc8.com

在Oracle中則可以使用wm_concat 或 ListAgg

01.CREATE TABLE MyTest(xType NUMBER,City nvarchar2(200));  
02./  
03.  
04.INSERT INTO MyTest(xType,City)  
05.SELECT 1,'北京' FROM dual UNION ALL  
06.SELECT 1,'上海' FROM dual UNION ALL  
07.SELECT 1,'广州' FROM dual UNION ALL  
08.SELECT 2,'武汉' FROM dual UNION ALL  
09.SELECT 2,'杭州' FROM dual UNION ALL  
10.SELECT 2,'厦门' FROM dual  
11.COMMIT;  

使用wm_Concat:

SELECT xType,wmsys.wm_concat(to_char(City)) AS xCity FROM MyTest GROUP BY xType 

使用ListAgg:

SELECT xType, ListAgg(to_char(City),',') WITHIN GROUP(ORDER BY xType) AS xCity FROM MyTest GROUP BY xType  

XTYPE          XCITY
----------   --------------------------------------
         1        北京,广州,上海
         2         杭州,武汉,厦门

数据库技术学习 https://www.itkc8.com