scott表下的EMP表
select * from EMP E start with E.EMPNO = '7839' connect by E.MGR = prior E.EMPNO; -----向下查询
select * from EMP E start with E.EMPNO = '7839' connect by prior E.MGR = E.EMPNO; ----向上查询
CONNECT BY prior EMPNO = MGR 对象字段为id,父对象字段为p_id,向下查询
CONNECT BY EMPNO = prior MGR 对象字段为id,父对象字段为p_id,向上查询