Oracle start with .... connect by 查询树结构数据
来源:互联网 发布:软件专业大专课程 编辑:程序博客网 时间:2024/05/14 06:26
create table bicycle
(
part_id number(5) ,
parent_id number(5) constraint fk_bicycle_pid references bicycle(part_id),
part_name varchar2(30) not null,
mp_cost number(9,2),
describe varchar2(30),
constraint pk_bicycle_part_id primary key (part_id)
);
insert into bicycle values(1,null,'自行车',379.28,'装配');
insert into bicycle values(2,1,'导向系统',101.11,'制造');
insert into bicycle values(3,1,'驱动系统',159.11,'制造');
insert into bicycle values(4,1,'其他部分',118.11,'制造和采购');
insert into bicycle values(5,2,'车把',37.11,'制造');
insert into bicycle values(6,2,'前叉',24.11,'制造');
insert into bicycle values(7,2,'前轴',19.11,'制造');
insert into bicycle values(8,2,'前轮',19.11,'制造');
insert into bicycle values(9,7,'前轴棍',8.11,'制造');
insert into bicycle values(10,7,'前轴身',4.11,'制造');
insert into bicycle values(11,7,'前轴碗',6.11,'制造');
insert into bicycle values(12,10,'前轴管',1.11,'制造');
insert into bicycle values(13,10,'前轴盘',3.11,'制造');
select level,t.* from bicycle t
start with t.part_id=1
connect by prior part_id=parent_id
(
part_id number(5) ,
parent_id number(5) constraint fk_bicycle_pid references bicycle(part_id),
part_name varchar2(30) not null,
mp_cost number(9,2),
describe varchar2(30),
constraint pk_bicycle_part_id primary key (part_id)
);
insert into bicycle values(1,null,'自行车',379.28,'装配');
insert into bicycle values(2,1,'导向系统',101.11,'制造');
insert into bicycle values(3,1,'驱动系统',159.11,'制造');
insert into bicycle values(4,1,'其他部分',118.11,'制造和采购');
insert into bicycle values(5,2,'车把',37.11,'制造');
insert into bicycle values(6,2,'前叉',24.11,'制造');
insert into bicycle values(7,2,'前轴',19.11,'制造');
insert into bicycle values(8,2,'前轮',19.11,'制造');
insert into bicycle values(9,7,'前轴棍',8.11,'制造');
insert into bicycle values(10,7,'前轴身',4.11,'制造');
insert into bicycle values(11,7,'前轴碗',6.11,'制造');
insert into bicycle values(12,10,'前轴管',1.11,'制造');
insert into bicycle values(13,10,'前轴盘',3.11,'制造');
select level,t.* from bicycle t
start with t.part_id=1
connect by prior part_id=parent_id
order by level;
查询的事包括子辈的和孙子辈的所有直属节点;
select level,t.* from bicycle t
start with t.part_id=1
connect by part_id=prior parent_id
order by level;
如果查找的是节点的直属父节点,也是不用用到树型查询的。 0 0
- Oracle start with .... connect by 查询树结构数据
- Oracle树结构查询 start with ... connect by用法简介
- oracle树结构查询(start with connect by prior )
- oracle分层查询中的start with和connect by(树结构查询)
- Oracle 递归查询 树查询 start with SQL CONNECT BY
- Oracle递归查询 start with Connect By
- oracle递归查询 start with...connect by
- oracle start with connect by递归查询
- oracle树形查询 start with connect by
- Oracle中Start with...Connect By循环加载树结构
- 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查询树型关系(connect by prior start with) .
- ORACLE查询树型关系(connect by prior start with)
- Oracle实现树查询:select ... start with ... connect by prior
- [层次结构|树状结构] oracle中用start with...connect by prior子句实现递归查询
- 中缀表达式转换为后缀表达式
- 从OpenGL传颜色数值到Shader,改变绘图颜色
- php 不四舍五入截取浮点型字符串
- QT程序在Windows下制作安装包发布程序的方法
- linux和windows下UDP发送效率的有趣比较
- Oracle start with .... connect by 查询树结构数据
- Hibernate几个异常总结
- Nginx惊群问题
- Java编程思想之多线程
- iPhone循环录音应用Heard:记录精彩瞬间
- python数据结构与算法 15 队列应用之烫手的山芋
- Exploit Exercises - Protostar Stack
- SVN trunk, branches and tags
- 下面设计一个三角形类,请给出各成员函数的定义