先查找e结点对应的子结点列表:
select node from t_tree
start with node = 'e' connect by parent node = node_paret;再去除掉就行了。
select node from t_tree where node not in(
select node from t_tree
start with node = 'e' connect by prior node = node_paret
);
select node from t_tree
start with node = 'e' connect by parent node = node_paret;再去除掉就行了。
select node from t_tree where node not in(
select node from t_tree
start with node = 'e' connect by prior node = node_paret
);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货