Oracle中connect by prior .... start with
来源:互联网 发布:数据库基础是啥 编辑:程序博客网 时间:2024/04/29 17:19
一 connect by prior ....start with
废话少说上测试代码.
create table test_table_c(id number primary key,description varchar(255),parent_id number);insert into test_table_c(id,description,parent_id) values(1,'cuiyaonan2',null);insert into test_table_c(id,description,parent_id) values(2,'cuiyaonan20',1);insert into test_table_c(id,description,parent_id) values(3,'cuiyaonan200',2);insert into test_table_c(id,description,parent_id) values(4,'cuiyaonan2000',3);insert into test_table_c(id,description,parent_id) values(5,'cuiyaonan2000@',4);insert into test_table_c(id,description,parent_id) values(6,'cuiyaonan2000@1',5);insert into test_table_c(id,description,parent_id) values(7,'cuiyaonan2000@16',6);显示结果为
执行语句
select * from test_table_c connect by prior parent_id = id start with id =7;
显示结果为:
执行语句
select * from test_table_c connect by parent_id = prior id start with id =1;
显示结果:
注释 :prior 表示上一条记录. prior +字段 表示上一条记录的某个字段.如
parent_id = prior id表示上一条记录的id与本条记录的parent_id值是否一致.
- Oracle中start with...connect by prior
- 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中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中start with...connect by prior子句用法
- Oracle中start with...connect by prior子句用法
- Oracle中start with...connect by prior子句用法
- iOS开发那些事-性能优化–查找和解决僵尸对象
- MapReduce之Join操作(4)
- unity 整合 vs2008 加快 unity c# 开发
- Haxe中保存位图为JPG格式
- 2012读书目录
- Oracle中connect by prior .... start with
- vc++ 自定义消息和WM_NOTIFY消息实现
- TCP协议传输的三次握手原理
- 在sharepoint 2010上如何创建一个调查
- 欧盟又盯上中国太阳能玻璃
- Linux脚本(shell)编程(一) 简单入门HelloWorld
- 转换为NSArray后,JSOn响应得到的是空值的解决方案
- 6droom 的新功能
- VC2010操作EXCEL