执行下面sql语句查看wmsys.wm_concat的用法
with a as (select 'zhangsan' as emp_name, '信息部' as emp_dept from dual
union all
select 'lisi' as emp_name, '信息部' as emp_dept from dual
union all
select 'wangwu' as emp_name, '财务部' as emp_dept from dual
union all
select 'zhaoliu' as emp_name, '财务部' as emp_dept from dual)
select a.emp_dept, wmsys.wm_concat(a.emp_name) name
from a
group by a.emp_dept;