有如下表id parentid
1 0
2 1
3 1
4 2
5 3我可以查出:
1
1/2
1/3
1/2/4
1/3/5select id,SUBSTR(SYS_CONNECT_BY_PATH(id, '/'), 2) full_path
from table1
connect by prior id = parentid
start with parentid = 0但是,我想得出如下结果,也就是路径从子结节往根节点的完整路径1
2/1
3/1
4/2/1
5/3/1
1 0
2 1
3 1
4 2
5 3我可以查出:
1
1/2
1/3
1/2/4
1/3/5select id,SUBSTR(SYS_CONNECT_BY_PATH(id, '/'), 2) full_path
from table1
connect by prior id = parentid
start with parentid = 0但是,我想得出如下结果,也就是路径从子结节往根节点的完整路径1
2/1
3/1
4/2/1
5/3/1
start with 条件改一下
应该可以吧
from table1
start with parentid = 0
connect by prior id = parentid