Oracle connect by prior查询用法

参考地址:https://blog.csdn.net/qq_33656602/article/details/77750576

如果表中存在层次数据,则可以使用层次化查询子句查询出表中行记录之间的层次关系
基本语法: 
[ START WITH CONDITION1 ]
CONNECT BY [ NOCYCLE ] CONDITION2
[ NOCYCLE ]
 

用法示例:

SELECT t.* FROM Score_Model t WHERE t.id = 552 OR t.pid = 552

SELECT t.* FROM Score_Model t START WITH t.id = 552 CONNECT BY PRIOR t.id = t.pid

SELECT t.* FROM Score_Model t START WITH t.id = 553 CONNECT BY t.id = PRIOR t.pid

SELECT t.* FROM Score_Model t START WITH t.id = 554 CONNECT BY t.id = PRIOR t.pid

原文地址:https://www.cnblogs.com/jason2018524/p/10833604.html