【转载】Oracle:connect_by_isleaf,start with...connect by prior
来源:互联网 发布:淘宝教程 华为网盘 编辑:程序博客网 时间:2024/05/29 10:55
select connect_by_isleaf isleaf,
tb.switch_type_id,
sys_connect_by_path(tb.package_id, '|') path,
tb.record_type,
tb.element_offset,
tb.element_length,
tb.element_encode_type,
tb.element_align,
tb.mask,
tb.asn_type
from (select b.switch_type_id,
b.package_id,
b.element_offset,
b.element_length,
b.element_encode_type,
nvl(b.element_align, 'L') element_align,
b.record_type,
nvl(b.mask, 'LH') mask,
b.asn_type,
b.switch_type_id || '|' || b.package_level || '|' || b.package_id level_child,
b.switch_type_id || '|' || (b.package_level - 1) || '|' || b.parent_package_id level_parent
from switch_asn_record b
) tb
start with tb.level_parent like '%|0|-1'
connect by prior tb.level_child = tb.level_parent;
1、connect_by_isleaf是否是子节点;
2、sys_connect_by_path(tb.package_id, '|') ==> |xxx|xxx|xxx
3、start with tb.level_parent like '%|0|-1' ==> 树的遍历以从什么开始
4、connect by prior tb.level_child = tb.level_parent; ==>此层遍历之后,再将child作为parent,继续往下遍历
tb.switch_type_id,
sys_connect_by_path(tb.package_id, '|') path,
tb.record_type,
tb.element_offset,
tb.element_length,
tb.element_encode_type,
tb.element_align,
tb.mask,
tb.asn_type
from (select b.switch_type_id,
b.package_id,
b.element_offset,
b.element_length,
b.element_encode_type,
nvl(b.element_align, 'L') element_align,
b.record_type,
nvl(b.mask, 'LH') mask,
b.asn_type,
b.switch_type_id || '|' || b.package_level || '|' || b.package_id level_child,
b.switch_type_id || '|' || (b.package_level - 1) || '|' || b.parent_package_id level_parent
from switch_asn_record b
) tb
start with tb.level_parent like '%|0|-1'
connect by prior tb.level_child = tb.level_parent;
1、connect_by_isleaf是否是子节点;
2、sys_connect_by_path(tb.package_id, '|') ==> |xxx|xxx|xxx
3、start with tb.level_parent like '%|0|-1' ==> 树的遍历以从什么开始
4、connect by prior tb.level_child = tb.level_parent; ==>此层遍历之后,再将child作为parent,继续往下遍历
0 0
- 【转载】Oracle:connect_by_isleaf,start with...connect by prior
- oracle 递归查询 CONNECT BY、START WITH、CONNECT_BY_ROOT、CONNECT_BY_ISLEAF、SYS_CONNECT_BY_PATH
- oracle 递归查询 CONNECT BY、START WITH、CONNECT_BY_ROOT、CONNECT_BY_ISLEAF、SYS_CONNECT_BY_PATH
- oracle 递归查询 CONNECT BY、START WITH、CONNECT_BY_ROOT、CONNECT_BY_ISLEAF、SYS_CONNECT_BY_PATH
- 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中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 递归
- connect by prior start with
- connect by prior start with
- 【转载】9个超酷的jQuery倒计时插件和教程
- 关于@override报错的问题
- 关于td中内容换行的问题
- MyEclipse常用设置和优化(转)
- oracle中prior的用法,connect by prior,树形目录
- 【转载】Oracle:connect_by_isleaf,start with...connect by prior
- HttpWatch工具简介及使用技巧(转载)
- Oracle SQL性能优化(转)
- sql,关于数字标题的问题
- 【转载】大型网站架构设计及技术总结(转载)
- 2013年07月19日
- Hibernate配置文件元素详解
- Hibernate 脏数据检查
- perl 文件读写合并数据分割 去重 windows