oracle多行数据合并成一行

select id ,listagg( name, ',' ) within group ( order by id ) as name from TABLE_NAME GROUP BY id;