select * from deptment d start with d.dep_parent_id in (select t.dep_id from test_depview t) connect by prior d.dep_id = d.dep_parent_id;
start with ....... connect by prior 递归查询 ， 如果不加prior 则不进行深入递归查查询
原文：https://www.cnblogs.com/mylbs123/p/14548784.html