oracle树形查询

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，向上查询