SELECT
ID,-- 单位ID
ORG_NAME,-- 单位名称
ORG_FCODE-- 上级单位ID
FROM
ORG_INFO START WITH ID = '当前单位ID'
CONNECT BY PRIOR ID = ORG_FCODE
SELECT
ID,-- 单位ID
ORG_NAME,-- 单位名称
ORG_FCODE-- 上级单位ID
FROM
ORG_INFO START WITH ID = '当前单位ID'
CONNECT BY PRIOR ID = ORG_FCODE