start with where条件 KSR

ORACLE START WITH と WHERE メモ

start with　文に　where　の位置

select  * 
from 
     tableA
where 
     treeID=1
start with 
           parentID = 0
connect by 
           parentID = prior childID 

select *
from
(select * from tableA where treeID=1)
start with
parentID = 0
connect by
parentID = prior childID


WHERE条件参照：[https://www.cnblogs.com/xcxcxcxc/p/5993835.html]
START WITH参照：[https://blog.csdn.net/weiwenhp/article/details/8218091]
無限ループ参照：[https://codezine.jp/article/detail/2691]
まだ見てない参照：[https://www.cnblogs.com/YuyuanNo1/p/7919332.html]