删除父节点同时删除该节点上的所有子节点(oracle) delete from node where node_id in( select node_id from node start with node_id = connect by prior node_id=up_node );