SELECT *
FROM TMP_MYSINGLE_ORG A
START WITH A.DEPARTMENTNUMBER = 'C10D0558'
CONNECT BY A.EPHIGHDEPTNUMBER = PRIOR A.DEPARTMENTNUMBER;
connect by
最新推荐文章于 2023-04-21 10:14:53 发布
SELECT *
FROM TMP_MYSINGLE_ORG A
START WITH A.DEPARTMENTNUMBER = 'C10D0558'
CONNECT BY A.EPHIGHDEPTNUMBER = PRIOR A.DEPARTMENTNUMBER;