oracle 11g SQL树查询

 
oracle 11g SQL树查询

1、sys_connect_by_path的使用

2、START WITH  CONNECT BY PRIOR 


例如：

  SELECT  t.parent_dealer_id   
             , t.dealer_id   
             ,LEVEL AS n_level  
              ,sys_connect_by_path( t.dealer_id, '/') AS path
              ,connect_by_isLeaf AS "isLeaf"
       FROM  c.dealer t  
      START WITH t.parent_dealer_id = 17600000  
     CONNECT BY PRIOR t.dealer_id = t.parent_dealer_id  

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/18900329/viewspace-1743637/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/18900329/viewspace-1743637/