– 查找一个节点的所有直属子节点(所有后代)
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;