Oracle connect by prior查询用法

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

用法示例：

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

Oracle connect by prior查询用法

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