Oracle 递归查询connect by 简单例子
来源:互联网 发布:网络推广优化是什么 编辑:程序博客网 时间:2024/05/16 07:23
最近回顾了下connect 的使用方法,在此做个简单的总结,以供参考。
主要用到以下几点:
connect by :递归规则
start with :递归开始条件
prior :
正树: 必须是 ‘父’= prior ‘子’
倒树: 必须是 ‘子’= prior ‘父’
sys_connect_by_path(字段名, 2个字段之间的连接符号) :用来显示当前成员相关的成员关系。
下面附上例子一枚:
WITH t AS
(
SELECT 1 AS emp_id,0 AS m_id FROM dual UNION
SELECT 2 AS emp_id,1 AS m_id FROM dual UNION
SELECT 3 AS emp_id,1 AS m_id FROM dual UNION
SELECT 4 AS emp_id,2 AS m_id FROM dual UNION
SELECT 5 AS emp_id,3 AS m_id FROM dual
)
SELECT emp_id,m_id,
sys_connect_by_path(emp_id, '~') full_parent_id
FROM t CONNECT BY PRIOR emp_id=m_id START WITH m_id=0;
结果:
- Oracle 递归查询connect by 简单例子
- oracle connect by prior 进行简单树查询(递归查询)
- Oracle递归查询 start with Connect By
- Oracle 递归查询connect by priop 注解
- oracle递归查询 start with...connect by
- oracle start with connect by递归查询
- Oracle 递归查询 Connect by prior
- oracle connect by prior 递归查询
- Oracle Connect By Prior(递归查询)
- oracle中用start with...connect by prior子句实现递归查询[例子不错]
- oracle connect by递归
- Oracle connect by 例子
- Oracle 递归查询 树查询 start with SQL CONNECT BY
- 级联查询 oracle 中connect by prior实现递归查询
- oracle 递归查询(树查询) connect by prior
- Oracle Connect By 查询
- Oracle用Start with...Connect By子句递归查询
- Oracle用Start with...Connect By子句递归查询
- iphone5的 A6与 A5X处理器只相差10%而已?
- js获取宽度 ,各种高度宽度document.body.clientWidth , document.body.clientHeight,window.screen.width 等等
- Win7系统下电脑睡眠和休眠的区别和常见问题
- Perl面向对象编程的两种实现和比较
- AM335x NAND Driver's Guide 中文手册
- Oracle 递归查询connect by 简单例子
- 分代收集器
- minimalcomps minimalconfigurator
- dd 命令详解
- 创建一个ramdisk文件系统
- perl---(数组和哈希)引用
- 软考复习资料。。。。
- 黑马程序员——反射之Constructor构造器
- AM335x LCD Controller Driver's Guide 中文手册