select t.* from TEST23 T;
select t.id,listagg(t.name,‘,‘)within group(order by t.id) name from TEST23 t group by t.id
listagg 列转换
原文:http://www.cnblogs.com/chainjun/p/6365929.html