SELECT
TORG.ORGCODE as "orgId",
SUBSTR( SYS_CONNECT_BY_PATH ( TORG.ORGNAME, '-' ), 2) AS "orgName"
FROM
T_ORG_IMPORT TORG
START WITH TORG.ORGCODE = '10201'
connect BY nocycle prior TORG.ORGCODE = TORG.PARENT_ORGCODE;
效果图如下:
SELECT
TORG.ORGCODE as "orgId",
SUBSTR( SYS_CONNECT_BY_PATH ( TORG.ORGNAME, '-' ), 2) AS "orgName"
FROM
T_ORG_IMPORT TORG
START WITH TORG.ORGCODE = '10201'
connect BY nocycle prior TORG.ORGCODE = TORG.PARENT_ORGCODE;
效果图如下: