树形表结构id parent_id0 -1
1 02 03 04 1
5 4想得出根节点和所有以他为根结点的子节点的对照如 root_id id parentid
0 1 0
0 2 0 0 3 0
1 4 1 1 5 4
1 02 03 04 1
5 4想得出根节点和所有以他为根结点的子节点的对照如 root_id id parentid
0 1 0
0 2 0 0 3 0
1 4 1 1 5 4
调试欢乐多
connect by id=prior parent_id10G可以这样写,9I就不晓得了
FROM TTT
START WITH PARENT_ID = 0
CONNECT BY PRIOR ID = PARENT_ID
ORDER BY 2;