oracel 树查询相关

来源:互联网 发布:兄弟加工中心编程 编辑:程序博客网 时间:2024/05/17 01:01

select ... from tablename start with cond1
connect by cond2
where cond3

子节点排序: ORDER SIBLINGS BY <expression>, only for 10g

LEVEL(层数), CONNECT_BY_ISLEAF(是否叶子节点)是两个有用的伪列

原创粉丝点击