SQL> create view emp_view as select * from emp;

View created.

SQL> select lpad(' ', 2 *level) || ename ename,
   2          hiredate
   3   from emp_view
   4   start with job='PRESIDENT'
   5   connect by prior empno=mgr
   6   order siblings by hiredate
   7   /

ENAME                          HIREDATE
 ------------------------------ ---------
 
  KING                          17 -NOV- 81 
    JONES                       02 -APR- 81 
      FORD                      03 -DEC- 81 
        SMITH                   17 -DEC- 80 
      SCOTT                     19 -APR- 87 
        ADAMS                   23 -MAY- 87 
    BLAKE                       01 -MAY- 81 
      ALLEN                     20 -FEB- 81 
      WARD                      22 -FEB- 81 
      TURNER                    08 -SEP- 81 
      MARTIN                    28 -SEP- 81 

ENAME                          HIREDATE
 ------------------------------ ---------
 
      JAMES                     03 -DEC- 81 
    CLARK                       09 -JUN- 81 
      MILLER                    23 -JAN- 82