SQL Oracle 递归查询语句

SQL SERVER 2008 递归子查询语句

WITH lmenu(id,orgFather,orgName,level) as (    SELECT id,orgFather,orgName,0 level FROM ORGANIZATION WHERE id='6c41bce0-4451-4a9f-aaba-dc3a9da0c30c'    UNION ALL    SELECT A.id,A.orgFather,A.orgName,b.level+1 FROM ORGANIZATION A,lmenu b    where a.orgFather = b.id)SELECT *  from lmenu

 

ORACLE  递归父类查询

SELECT * FROM CDT_ARTICLE_TYPE START WITH LBBH = 8499 CONNECT BY PRIOR SJLBBH = LBBH ORDER BY ORD ASC