递归连接查询

最新推荐文章于 2022-04-26 18:32:12 发布

dfbmd42668

最新推荐文章于 2022-04-26 18:32:12 发布

阅读量123

点赞数

原文链接：http://www.cnblogs.com/xuzhiwei/p/4021587.html

版权

select * from DT_INDUSTRY t 
start with industrycode IN (select industrycode from SYS_COMPANY_INDUSTRY t WHERE t.compid='541572482EDA4D4A9AA6E4AFB31A3782')

connect by prior INDUSTRYPCODE = industrycode

  SELECT SUBSTR(MAX(SYS_CONNECT_BY_PATH(NAME, '@sirc')), 6) AS NAME,
                 SUBSTR(MAX(SYS_CONNECT_BY_PATH(ID, '@sirc')), 6) AS ID    
            FROM SpecificFolderRelation B
           START WITH B.ID = P_ID
          CONNECT BY PRIOR B.PARENTID = B.ID;

转载于:https://www.cnblogs.com/xuzhiwei/p/4021587.html