树形找父级或子级

SELECT *

FROM ORGANIZE

-- START WITH PARENT_ID = 28001
-- CONNECT BY PRIOR PARENT_ID = TID

父级：

SELECT *

FROM ORGANIZE

START WITH TID = 28001
CONNECT BY PRIOR PARENT_ID = TID
子级：

SELECT *

FROM ORGANIZE

START WITH TID = 28001
CONNECT BY PRIOR TID = PARENT_ID

posted @ 2024-01-18 15:31  酷盖的小机灵  阅读(2)  评论(0)  编辑  收藏  举报