删除父节点同时删除该节点上的所有子节点(oracle)
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
);