sys_connect_by_path row데이터를 column데이터로

 select sys_connect_by_path(name, ',') as list
   from (select code01,
                     code02, 
                     name,
                     row_number() over(partition by code01 order by code01, code02) rn,
                     count(*) over(partition by code01) cnt
            from tb_aaa
          where code01='01' )
   where level = cnt
     start with rn = 1
connect by prior code01 = code01
           and prior rn = rn - 1