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