oracle查询所有叶子节点以及递归字段介绍

 

 

1、connect_by_isleaf是否是子节点；(1是,0否)
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，继续往下遍历

实例

查找所有的叶子节点

select * from (
select o.* from application_info o where  CONNECT_BY_ISLEAF =1 start with o.app_parent_id = 'HCGL'
connect by prior  o.app_id =o.app_PARENT_ID) where url is null