通过START WITH 和CONNECT BY PRIOR遍历上级父节点(上级目录)
来源:互联网 发布:java 多用户商城 编辑:程序博客网 时间:2024/05/16 16:11
向上遍历父节点
SELECT *FROM (SELECT *FROM m_comn_project_emp t1WHERE t1.project_id = 'Project1') t2START WITH t2.child_id = 'D'CONNECT BY PRIOR t2.parent_id = t2.child_id
向上遍历子节点
SELECT *FROM (SELECT *FROM m_comn_project_emp t1WHERE t1.project_id = 'Project1') t2START WITH t2.child_id = 'B'CONNECT BY PRIOR t2.child_id = t2.parent_id
向上遍历父节点不包含头节点
SELECT t2.member_id AS member_idFROM (SELECT *FROM m_comn_project_emp t1WHERE t1.project_id = :projectid) t2WHERE LEVEL > 1START WITH t2.member_id = :memberidCONNECT BY PRIOR t2.manager_id = t2.member_id
向上遍历子节点不包含头节点
SELECT t2.member_id AS member_idFROM (SELECT *FROM m_comn_project_emp t1WHERE t1.project_id = :projectid) t2WHERE LEVEL > 1START WITH t2.member_id = :memberidCONNECT BY PRIOR t2.member_id = t2.manager_id
- 通过START WITH 和CONNECT BY PRIOR遍历上级父节点(上级目录)
- Oracle 遍历树 start with () connect by prior ()
- connect by prior start with
- connect by prior start with
- CONNECT BY PRIOR... START WITH
- connect by prior start with
- Start With......Connect by prior..
- start with connect by prior
- connect by prior...start with...
- start with ... connect by prior ...
- start with ... CONNECT BY PRIOR
- start with --connect by prior
- START WITH CONNECT BY PRIOR
- start with connect by prior
- oracle 使用start with connect by nocycle prior 和UnionAll
- oracle树结构查询(start with connect by prior )
- oracle树操作(select .. start with .. connect by .. prior)
- connect by prior start with 总结
- JSR 248 -- Mobile Service Architecture Specification
- [转]Oracle With 语法 示例
- "A transport-level error has occurred when sending the request to the server"的解决办法
- GridView和CheckBox控制选择行上下移动
- Sir Winston Churchill 温斯顿▪丘吉尔爵士
- 通过START WITH 和CONNECT BY PRIOR遍历上级父节点(上级目录)
- Oracle的MERGE用法
- 我不喜欢理智的女人,一点都不喜欢
- 开BLOG语:being a CODER
- 华硕笔记本重装XP经历分享----------(光驱不启动、xp驱动)
- 版本1.0配置文件
- 版本2.0字典类型
- 利用OGRE的海洋例子改成的水编辑器
- 这是我第一次写博客,该写点什么捏