I beleive yes ( if you are looking into something like this).
This query gives an output of names of employees based on job heirarchy of employees
SQL> column Name format a30
SQL> ed
Wrote file afiedt.buf
1 select job,lpad(' ',5*(level-1))||ename Name
2 from emp e
3 connect by prior empno = mgr
4* start with mgr is null
SQL> /
JOB NAME
--------- ------------------------------
PRESIDENT KING
MANAGER JONES
ANALYST SCOTT
CLERK ADAMS
ANALYST FORD
CLERK SMITH
MANAGER BLAKE
SALESMAN ALLEN
SALESMAN WARD
SALESMAN MARTIN
SALESMAN TURNER
CLERK JAMES
MANAGER CLARK
CLERK MILLER
14 rows selected.