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

 

posted @ 2018-12-07 15:25  FlatWang  阅读(563)  评论(0)  编辑  收藏  举报