Oracle拼接数据

---用逗号隔开查询数据 两种方式
select wmsys.wm_concat(name) from table_name;

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