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 

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]