:
SELECT *
FROM Employee
START WITH ParentID IS NULL
CONNECT BY PRIOR ID = ParentID
ORDER SIBLINGS BY LastName, FirstName, ID;
:
您不需要为此进行分层查询。(父级由bind变量指定:parent_id
)
SELECT *
FROM Employee
WHERE ParentID = :parent_id
ORDER BY LastName, FirstName, ID;
:
与整个树相同的查询,但是起点不同(父级由bind变量指定:parent_id
)
SELECT *
FROM Employee
START WITH ParentID = :parent_id
CONNECT BY PRIOR ID = ParentID
ORDER SIBLINGS BY LastName, FirstName, ID;
:
与上一个查询类似,但取CONNECT BY
反,您无需订购兄弟姐妹,因为每个员工只有一名直属经理。(员工由bind变量给定:employee_id
)
SELECT *
FROM Employee
START WITH ID = :employee_id
CONNECT BY PRIOR ParentID = ID;
:
与上一个查询相同,但具有LEVEL = 2
仅获取直接父行的过滤器。(员工由bind变量给定:employee_id
)
SELECT e.*
FROM Employee e
WHERE LEVEL = 2
START WITH ID = :employee_id
CONNECT BY PRIOR ParentID = ID;