Oracle用Start with...Connect By子句递归查询
来源:互联网 发布:淘宝视频 编辑:程序博客网 时间:2024/04/29 07:49
Start with...Connect By子句递归查询一般用于一个表维护树形结构的应用。
创建示例表:
CREATE TABLE TBL_TEST
(
ID NUMBER,
NAME VARCHAR2(100 BYTE),
PID NUMBER DEFAULT 0
);
(
ID NUMBER,
NAME VARCHAR2(100 BYTE),
PID NUMBER DEFAULT 0
);
插入测试数据:
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('1','10','0');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('2','11','1');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('3','20','0');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('4','12','1');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('5','121','2');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('2','11','1');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('3','20','0');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('4','12','1');
INSERT INTO TBL_TEST(ID,NAME,PID) VALUES('5','121','2');
从Root往树末梢递归
select * from TBL_TEST
start with id=1
connect by prior id = pid
start with id=1
connect by prior id = pid
从末梢往树ROOT递归
select * from TBL_TEST
start with id=5
connect by prior pid = id
start with id=5
connect by prior pid = id
原文地址:
http://blog.csdn.net/54powerman/archive/2006/04/03/649068.aspx
- 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用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用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 Start with...Connect By子句递归查询
- oracle关键字 start with、、、 connect by prior 子句递归查询
- Oracle start with......connect by prior......子句实现递归查询
- jsp格式标签
- 转义字符序列
- Oracle、SQL Server、Access的区别
- Linux常识&技能
- 关于private public protected 的使用
- Oracle用Start with...Connect By子句递归查询
- oracle 中oci 关于null 的处理方法
- Android 快速运行的秘诀
- 枚举
- http://web9.zyns.com/
- 关于ComboBox显示下拉列表的时候显示不出来的解决方法
- collections
- android widget
- Android复习:Activity