listagg 列转换

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