含有父子关系的上下节点SQL

– 查找一个节点的所有直属子节点(所有后代)

SELECT org_name, org_type_id, org_id, porg_id  FROM T_ORGanization_structure START WITH ORG_ID = '9ad287364b3b8ee053a15f4da591' CONNECT BY PORG_ID = PRIOR ORG_ID;   

– 查找一个节点的所有直属父节点（追溯祖宗）

SELECT * FROM T_ORGanization_structure START WITH ORG_ID = '09446f8f4472aef2d7ddde706d61' CONNECT BY PRIOR PORG_ID = ORG_ID;