SELECT
DEPTCODE,
DEPTID,
DEPTNAME,
UPDEPTCODE,
ISTEAM,
tel,
CITY,
PROVINCE,
ADDRESS,
IS_HQ,
DEPTNO,
level_code,
czy
FROM BACK_ORGANIZATION_INFO
start with deptcode='0'
connect by prior deptid= updeptcode
以deptcode=0开始,开始想向下遍历,一下下列出结果