大致如下：select id, wmsys.wm_concat(name) as name from tabname group by id
老版本可以使用wm_concatselect wm_concat(name) from tbname ;11gr2可以使用listaggselect listagg(name,',') within group(order by name) from tbname ;
