--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 rnFROM user_tab_cols a--order by table_name,column_idwhere a.table_name='TABLE_NAME') t1START WITH t1.rn = 1CONNECT BY t1.table_name = PRIOR t1.table_nameAND t1.rn - 1 = PRIOR t1.rnGROUP BY t1.table_name;

评论