oracle与DB2递归查询

DB2 通过WITH AS递归查询

WITH TA (ORG_ID, ORG_NAME, PARENT_ORG_ID)
        AS (SELECT ORG_ID, ORG_NAME, PARENT_ORG_ID
              FROM TM_ORG
             WHERE org_ID = 1
            UNION ALL
            SELECT B.ORG_ID, B.ORG_NAME, B.PARENT_ORG_ID
              FROM TM_ORG B, TA A
             WHERE B.PARENT_ORG_ID = A.org_id)
SELECT ORG_ID, ORG_NAME, PARENT_ORG_ID
  FROM TA

 

oracle 通过 start with connect by prior 递归查询

select * from TM_ORG start with org_id = 1 connect by prior org_id = PARENT_ORG_ID;