oracle的递归

       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开始，开始想向下遍历，一下下列出结果