Oracle 两个函数listagg wm_concat

1、listagg或wm_concat查询出来没有数据，首先确保是否存在数据，其次检测下要合并的字段是否为nvarchar2,如果是这个字段话要进行下to_char转换，不然查出来的是空白

LISTAGG( to_char(Item_Category_Name), ',') WITHIN GROUP(ORDER BY Item_Category_Name)  -- 将 Item_Category_Name 列的内容以", "进行分割合并、排序；

例子：select r.buildingid, wm_concat(r.roomname) as listname, count(r.buildingid) from room r group by r.buildingid

select r.buildingid, LISTAGG( to_char(r.roomname), ',') WITHIN GROUP(ORDER BY r.roomnum) as listname, count(r.buildingid) from room r group by r.buildingid

记过数据如下所示：