SELECT LEVEL, t.id1,t.id2, max(ltrim(sys_connect_by_path(col2, ' '),' ')) path from ( SELECT col1 id1 ,(col1+1) id2 ,col2 FROM m_table ORDER BY col1 ) t connect by prior id2 = id1 start with id1 = 1 GROUP BY id1,id2 ,LEVEL ORDER BY LEVEL,path我是构造了一棵树,然后遍历树,没测试过,下班了,先走了.希望高人指点,我的方法不是很好.
关于这中行列转换的例子多的事,我就不给你具体的写了
( SELECT col1 id1 ,(col1+1) id2 ,col2 FROM m_table ORDER BY col1 ) t
connect by prior id2 = id1 start with id1 = 1
GROUP BY id1,id2 ,LEVEL
ORDER BY LEVEL,path我是构造了一棵树,然后遍历树,没测试过,下班了,先走了.希望高人指点,我的方法不是很好.