connect by prior start with 用法
来源:互联网 发布:java wait与notify 编辑:程序博客网 时间:2024/04/28 01:11
Oracle用Start with...Connect By子句递归查询
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
- connect by prior start with 用法
- start with...connect by prior子句用法
- Oracle start with ... connect by prior 用法
- 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 用法
- START WITH...CONNECT BY PRIOR用法
- oracle start with connect by prior 用法
- connect by prior start with
- connect by prior start with
- CONNECT BY PRIOR... START WITH
- connect by prior start with
- Start With......Connect by prior..
- start with connect by prior
- connect by prior...start with...
- start with ... connect by prior ...
- 历史上的十二个重要时刻
- MCPD认证微软认证专业开发人士
- ASP.NET 2.0 中的 Web Resource
- 美国历史上待解八大悬疑
- [C]sprintf用法
- connect by prior start with 用法
- 智能信息发布系统解决方案
- 两份矛盾的电报--中国出兵朝鲜档案解密
- “四大名旦”如何唱红上海滩?(图)
- 基于InforFlow的政府信息门户及办公平台解决方案
- 内幕揭秘:第一颗原子弹爆炸内情
- 强大的流程建模与流程控制的工作流中间件InforFlow2.1
- DLL(转自百度百科)
- 苏联出兵东北始末