分组后合并字段方法
select [分组的字段],ltrim(max(sys_connect_by_path([要合并的字段], ',')), ',') [要合并的字段]
from (
select [分组的字段],[要合并的字段],row_number()over(partition by [分组的字段] order by [要合并的字段]) rn
from 表名)
start with rn=1
connect by prior rn=rn-1 and prior [分组的字段]=[分组的字段]
group by [分组的字段]
order by [分组的字段];