select category ,MAX(sys_connect_by_path(t.name, ',')) as cate_name from(
select a.category,a.name,row_number() over(PARTITION BY category ORDER BY name) as rn from biz_code a
) t
START WITH rn = 1
CONNECT BY rn = PRIOR rn + 1
AND category = PRIOR t.category
GROUP BY t.category