Oracle查询树型关系(start with connect by prior)
来源:互联网 发布:实名认证数据网 编辑:程序博客网 时间:2024/05/18 06:27
用于B树结构类型的数据递归查询,给出B树结构类型中的任意一个结点,遍历其最终父结点或者子结点:
--创建测试表create table dept_test_demo( id VARCHAR2(5) not null, dept VARCHAR2(5), parent_dept VARCHAR2(5))--插入数据insert into dept_test_demo(id,dept,parent_dept) values ('1','1','');insert into dept_test_demo(id,dept,parent_dept) values ('2','2','1');insert into dept_test_demo(id,dept,parent_dept) values ('3','3','1');insert into dept_test_demo(id,dept,parent_dept) values ('4','21','2');insert into dept_test_demo(id,dept,parent_dept) values ('5','22','2');insert into dept_test_demo(id,dept,parent_dept) values ('6','23','2');insert into dept_test_demo(id,dept,parent_dept) values ('7','222','22');insert into dept_test_demo(id,dept,parent_dept) values ('8','31','3');insert into dept_test_demo(id,dept,parent_dept) values ('9','32','3');insert into dept_test_demo(id,dept,parent_dept) values ('10','33','3');insert into dept_test_demo(id,dept,parent_dept) values ('11','333','33');
select * from dept_test_demo
如上图所示,1是父部门,2,3是1的子部门;21、22、23是2的子部门,222是22的子部门;31、32、33是3的子部门,333是33的子部门。
现在我们查看部门2及其所有子部门
select * from dept_test_demo d start with d.dept = 2 connect by prior d.dept = d.parent_dept
现在我们查看部门2及其所有父部门
select * from dept_test_demo d start with d.dept = 2 connect by d.dept = prior d.parent_dept
1 0
- ORACLE查询树型关系(connect by prior start with)
- ORACLE查询树型关系(connect by prior start with) .
- ORACLE查询树型关系(connect by prior start with)
- ORACLE查询树型关系(connect by prior start with)
- ORACLE查询树型关系(connect by prior start with)
- ORACLE查询树型关系(start with connect by prior)
- ORACLE查询树型关系(connect by prior start with)
- 【转】ORACLE查询树型关系(start with connect by prior)
- ORACLE查询树型关系(connect by prior start with)
- ORACLE查询树型关系(start with connect by prior)
- Oracle查询树型关系(start with connect by prior)
- oracle树结构查询(start with connect by prior )
- ORACLE树查询,start with connect by prior
- ORACLE树查询,start with ... connect by prior ...
- ORACLE树查询,start with connect by prior
- Oracle实现树查询:select ... start with ... connect by prior
- Oracle 遍历树 start with () connect by prior ()
- oracle树操作(select .. start with .. connect by .. prior)
- nodejs更新MongoDB数据库中文问题
- Kubernetes对Container Capabilities的支持
- Linux中的信号量(上)
- 如何做个依赖库让别人依赖使用
- 杀人放火金腰带,修桥补路无尸骸:成功的真相
- Oracle查询树型关系(start with connect by prior)
- openstack(m版)官网创建云主机过程
- HomeBrew安装
- 【JQuery学习总结2 】Jquery字符串, 数组(拷贝、删选、合并等), each循环,阻止冒泡,ajax出错,$.grep筛选,$.param序列化
- java面试
- Day006:Linked List Cycle II
- openwrt创建子端口
- c#mvc redirecttoaction 和redirect的区别
- ABIX.v6.69.01.Bilanguage.WinAll-LAXiTY\