创建一个树型结构的表
其中parent_id指向父节点的id
查询树形结构可以用
SELECT
id,PARENT_ID,name,level
FROM t_tree_nodes
CONNECT BY parent_id = PRIOR id
START WITH id in ('10007')
将结果按根节点分组可以用
SELECT CONNECT_BY_ROOT id,CONNECT_BY_ROOT name,t.* FROM t_tree_nodes t CONNECT BY parent_id = PRIOR ID START WITH ID = '10007'
CONNECT_BY_ROOT 关键字用以修饰根节点的元素