orcle，达梦库，根据父节点查询所有子集

orcle，达梦库，根据父节点查询所有子集（向下查询）

 SELECT DISTINCT po.ORG_CODE  FROM PRS_ORG po
                     WHERE po.SET_YEAR = T1.SET_YEAR AND  po.AGENCY_CODE =T1.AGENCY_CODE AND  po.RG_CODE =T1.RG_CODE
                    START WITH po.ORG_CODE = #{orgCode,jdbcType=VARCHAR}
                    CONNECT BY PRIOR po.ORG_CODE =  po.parent_id
                    ORDER BY po.org_code

orcle，达梦库，根据子节点查询所有父节点（向上查询）

 SELECT DISTINCT po.ORG_CODE  FROM PRS_ORG po
                     WHERE po.SET_YEAR = T1.SET_YEAR AND  po.AGENCY_CODE =T1.AGENCY_CODE AND  po.RG_CODE =T1.RG_CODE
                    START WITH po.ORG_CODE = #{orgCode,jdbcType=VARCHAR}
                    CONNECT BY  po.ORG_CODE = PRIOR   po.parent_id
                    ORDER BY po.org_code