列转行的语句解决方法

--note:利用分析函数功能

SELECT t1.table_name,
 substr(MAX(sys_connect_by_path(t1.column_name, ';')), 2)  column_name --分号分隔
FROM (SELECT a.table_name,
a.column_name,
row_number() over(PARTITION BY a.table_name ORDER BY a.column_id) rn
--column_id rn
FROM user_tab_cols a
--order by table_name,column_id
where a.table_name='TABLE_NAME'
) t1
START WITH t1.rn = 1
CONNECT BY t1.table_name = PRIOR t1.table_name
AND t1.rn - 1 = PRIOR t1.rn
GROUP BY t1.table_name;