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.