Oracle connect by prior查询用法

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

 

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。 如果表中存在层次数据，则可以使用层次化查询子句查询出表中行记录之间的层次关系 基本语法：  [ 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

扫码关注我们

微信号：SRE实战

拒绝背锅 运筹帷幄