--子取父
select * from tb_org CONNECT BY PRIOR orgparent=orgid START WITH orgid='newsroom'
-----子取父变形 （）
select * from tb_org CONNECT BY PRIOR orgparent=orgid START WITH orgparent='newsroom'
--父取子（结果中没有父这条记录）
select * from tb_org CONNECT BY PRIOR orgid=orgparent START WITH orgparent='newsroom'
-----父取子变形（多了父这一级）
select * from tb_org connect by prior orgid=orgparent start with orgid ='newsroom'
select * from tb_org CONNECT BY PRIOR orgparent=orgid START WITH orgid='newsroom'
-----子取父变形 （）
select * from tb_org CONNECT BY PRIOR orgparent=orgid START WITH orgparent='newsroom'
--父取子（结果中没有父这条记录）
select * from tb_org CONNECT BY PRIOR orgid=orgparent START WITH orgparent='newsroom'
-----父取子变形（多了父这一级）
select * from tb_org connect by prior orgid=orgparent start with orgid ='newsroom'
866
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
