listagg函数
select a ,b ,c ,listagg(列名, '连接符') within group(order by 列名) from table group by 列名 order by a ,b ,c
若查询对象是中文, 结果为乱码 对查询结果列进行包装处理(同理可解决其他查询结果的处理问题):
select a ,b ,c ,listagg(to_char(列名), '连接符') within group(order by 列名) from table group by 列名 order by a ,b ,c
select Listagg(a,',') within group(order by a) from table group by a
select Listagg(a,',') within group(order by b) from table group by a
