通过START WITH 和CONNECT BY PRIOR遍历上级父节点（上级目录）

最新推荐文章于 2023-09-22 18:22:58 发布

thomas0104

最新推荐文章于 2023-09-22 18:22:58 发布

阅读量520

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/thomas0104/article/details/84199751

版权

数据库专栏收录该内容

12 篇文章 0 订阅

订阅专栏

向上遍历父节点
SELECT *
FROM (SELECT *
FROM m_comn_project_emp t1
WHERE t1.project_id = 'Project1') t2
START WITH t2.child_id = 'D'
CONNECT BY PRIOR t2.parent_id = t2.child_id向上遍历子节点
SELECT *
FROM (SELECT *
FROM m_comn_project_emp t1
WHERE t1.project_id = 'Project1') t2
START WITH t2.child_id = 'B'
CONNECT BY PRIOR t2.child_id = t2.parent_id 向上遍历父节点不包含头节点
SELECT t2.member_id AS member_id
FROM (SELECT *
FROM m_comn_project_emp t1
WHERE t1.project_id = :projectid) t2
WHERE LEVEL > 1
START WITH t2.member_id = :memberid
CONNECT BY PRIOR t2.manager_id = t2.member_id 向上遍历子节点不包含头节点
SELECT t2.member_id AS member_id
FROM (SELECT *
FROM m_comn_project_emp t1
WHERE t1.project_id = :projectid) t2
WHERE LEVEL > 1
START WITH t2.member_id = :memberid
CONNECT BY PRIOR t2.member_id = t2.manager_id