首页 > 数据库技术 > 详细

Oracle 递归查询

时间:2015-09-02 00:21:24      阅读:141      评论:0      收藏:0      [点我收藏+]
 1 select a.accountcodeid, a.accountcode, a.accountcodename,
 2        SYS_CONNECT_BY_PATH(a.accountcodename, \) as fullname, a.parentcodeid, level
 3   from fm_accountcode a
 4  where a.accountcodeid >= 10000
 5  start with a.parentcodeid is null
 6 connect by prior a.accountcodeid = a.parentcodeid;
 7 
 8 select a.accountcodeid, a.accountcode, a.accountcodename,
 9        SYS_CONNECT_BY_PATH(a.accountcodename, \) as fullname,
10        a.parentcodeid
11   from fm_accountcode a
12  where a.accountcodeid > 10000
13    and connect_by_isleaf = 1
14  start with a.parentcodeid is null
15 connect by prior a.accountcodeid = a.parentcodeid;

oracle 中递归查询,对树型结构数据相当有用。

二者区别:上,所有数据,包含结构;下,所有末节点,包含结构,具体参见Oracle Document 11g。

Oracle 递归查询

原文:http://www.cnblogs.com/jekon/p/4776935.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!