oracle递归指定层级,oracle递归层级查询 start with connect by prior

递归层级查询:start with connect by prior

以部门表作为解析

表结构:dept{id:'主键',name:'部门名称',parent_id:'父亲id'}

select * from dept

start with id=1 connect by prior id= parent_id

order siblings by id

分两部分理解:

第一步找出一条数据作为基础:select * from dept start with id =？

第二步prior放在左边还是右边是关键。

查询子节点:prior id = parent_id。以id作为需要匹配对象找出parent_id相等的数据。以上面sql作为例子 1= parent_id找出满足这样条件的记录。

查询父节点:id = prior parent_id。以parent_id作为需要匹配的对象，找出id等于parent_id的记录。

最后：观察数据结果集层级是否正确。

[转]Oracle 树操作(select…start with…connect by…prior)

转自http://www.cnblogs.com/linjiqin/archive/2013/06/24/3152674.html Oracle 树操作(select-start with-conne ...

SQL基础-->层次化查询(START BY ... CONNECT BY PRIOR)[转]

--====================================================== --SQL基础-->层次化查询(START BY ... CONNECT BY ...

SQL基础-->层次化查询(START BY ... CONNECT BY PRIOR)

--====================================================== --SQL基础-->层次化查询(START BY ... CONNECT BY ...

Oracle 之 树查询 START WITH ... CONNECT BY ...子句

START WITH ... CONNECT BY ...子句是结构化查询中用到的,其基本语法是: select … from tablename start with 条件1 connect by ...

Oracle 树操作(select…start with…connect by…prior)

摘自:http://www.cnblogs.com/linjiqin/archive/2013/06/24/3152674.html oracle树查询的最重要的就是select…start with ...

oracle树操作(select start with connect by prior)

oracle中的递归查询可以使用:select .. start with .. connect by .. prior 下面将会讲述oracle中树形查询的常用方式,只涉及到一张表. 一. 建表语句 ...

Oracle学习之Oracle 树操作(select…start with…connect by…prior)

转自:http://www.cnblogs.com/linjiqin/archive/2013/06/24/3152674.html oracle树查询的最重要的就是select…start with ...

(转载)Oracle 树操作(select…start with…connect by…prior)

转载地址:https://www.cnblogs.com/linjiqin/p/3152674.html 备注:如有侵权,请立即联系删除. oracle树查询的最重要的就是select…start w ...

[转]Oracle 树操作(select…start with…connect by…prior)