Hierarchial Queries

SQL> select empno, ename, job, mgr from emp
2 start with empno=7521
3 connect by prior mgr=empno;

EMPNO ENAME JOB MGR
---------- ---------- --------- ----------
7521 WARD SALESMAN 7698
7698 BLAKE MANAGER 7839
7839 KING PRESIDENT