ORACLE 查询当前节点包括所有子节点

查询该节点、包括该节点所有的子节点


select t.id  from mro_repair_scheme 
t start with t.id='8a58bca735adc3730135ae4a3f900176'
connect by prior t.id=t.mro_repair_scheme_pid 


删除该节点、包括该节点的所有子节点


delete  from mro_repair_scheme 
t where t.id in ( select t.id  
from mro_repair_scheme t start with 
t.id='8a58bca735adc3730135ae4a3f900176' 
connect by prior t.id=t.mro_repair_scheme_pid );