oracle中使用start with connect by prior

在Oracle数据中使用start with connect by prior递归查询下级节点

1、自己所有的后代节点（包括自己）

start with 子节点ID='...' connect by prior 子节点ID = 父节点ID
select * from mdm_organization o start with o.org_code='10000008' connect by prior o.org_code=o.org_parent_code

2、自己所有的后代节点（不包括自己）

start with 父节点ID='...' connect by prior 子节点ID = 父节点ID
select * from mdm_organization o start with o.org_parent_code='10000008' connect by prior o.org_code=o.org_parent_code

3、自己所有的前代节点（包括自己）

start with 子节点ID='...' connect by 子节点ID = prior 父节点ID
select * from mdm_organization o start with o.org_code='10000008' connect by o.org_code=prior o.org_parent_code