create table empl(Empno	number, Ename	varchar2(100),Mgrno number,Sal	number(7,2),A_Sal number(9,2));

INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (1,'KING', NULL, 10000, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (2,'BLAKE',1, 1000, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (3,'ALLEN', 2, 100, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (4,'JAMES', 2, 200, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (5,'MARTIN', 2, 300, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (6,'TURNER', 2, 400, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (7,'WARD', 2, 500, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (8,'CLARK', 1, 2000, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (9,'MILLER', 8, 600, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (10,'JONES', 1, 3000, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (11,'FORD', 10, 700, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (12,'SMITH', 11, 111, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (13,'SCOTT', 10, 800, NULL);
INSERT INTO empl (Empno, Ename, Mgrno, Sal, A_Sal) VALUES (14,'ADAMS', 13, 222, NULL);

KING
   BLAKE
      ALLEN
      JAMES
      MARTIN
      TURNER
      WARD
   CLARK
      MILLER
   JONES
      FORD
         SMITH
      SCOTT
         ADAMS

col ename format a15
SQL> select rpad('-',2*(level-1),'-')||ename ename, sal,
  2         ( select sum(sal) 
  3           from emp e2 
  4           connect by prior empno = mgr 
  5           start with e2.empno = emp.empno ) a_sal
  6  from emp
  7  connect by prior empno = mgr
  8  start with mgr is null
  9  /
ENAME                  SAL      A_SAL
--------------- ---------- ----------
KING                  5000      29025
--JONES               2975      10875
----SCOTT             3000       4100
------ADAMS           1100       1100
----FORD              3000       3800
------SMITH            800        800
--BLAKE               2850       9400
----ALLEN             1600       1600
----WARD              1250       1250
----MARTIN            1250       1250
----TURNER            1500       1500
----JAMES              950        950
--CLARK               2450       3750
----MILLER            1300       1300