查询该节点、包括该节点所有的子节点
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 );
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 );