delete from node
where node_id in(
select node_id
from node
start with node_id =
connect by prior node_id=up_node
);
delete from node
where node_id in(
select node_id
from node
start with node_id =
connect by prior node_id=up_node
);
转载于:https://www.cnblogs.com/jimmyLei/p/9333974.html