Oracle中使用sys_connect_by_path函数实现行转列

 

 

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