SQL> select empno, ename, sal, comm, job, mgr, e.deptno
  2    from (select *
  3            from scott.emp
  4          connect by prior empno = mgr
  5           start with mgr is null) e,
  6         scott.dept d
  7   where e.deptno = d.deptno
  8  /

EMPNO ENAME            SAL      COMM JOB         MGR DEPTNO
----- ---------- --------- --------- --------- ----- ------
 7839 KING         5000,00           PRESIDENT           10
 7566 JONES        2975,00           MANAGER    7839     20
 7788 SCOTT        3000,00           ANALYST    7566     20
 7876 ADAMS        1100,00           CLERK      7788     20
 7902 FORD         3000,00           ANALYST    7566     20
 7369 SMITH         800,00           CLERK      7902     20
 7698 BLAKE        2850,00           MANAGER    7839     30
 7499 ALLEN        1600,00    300,00 SALESMAN   7698     30
 7521 WARD         1250,00    500,00 SALESMAN   7698     30
 7654 MARTIN       1250,00   1400,00 SALESMAN   7698     30
 7844 TURNER       1500,00      0,00 SALESMAN   7698     30
 7900 JAMES         950,00           CLERK      7698     30
 7782 CLARK        2450,00           MANAGER    7839     10
 7934 MILLER       1300,00           CLERK      7782     10

14 rows selected

SQL> 

 1
    1.1
       1.1.1
       1.1.2
    1.2
       1.2.1
    1.3
  2
     2.1
        2.1.1
        2.1.2
        2.1.3
     2.2 

2.2
1.1.1
1.3

 1
    1.1
       1.1.1
   1.3
  2
     2.2 

SQL> select ename, deptno from emp
  2  start with mgr is null
  3  connect by prior empno = mgr;

ENAME          DEPTNO
---------- ----------
KING
JONES
SCOTT              20
ADAMS
FORD
SMITH
BLAKE              30
ALLEN
WARD
MARTIN             30
TURNER
JAMES
CLARK
MILLER

14 rows selected.

SQL> select lpad('-',lvl,'-') || '>' || t1.ename
  2  from
  3  (select ename, empno, level lvl
  4  from emp start with mgr is null
  5  connect by prior empno = mgr) t1
  6  ,
  7  (select unique empno
  8  from emp start with deptno in (select deptno from dept)
  9  connect by prior mgr = empno) t2
 10  where t1.empno = t2.empno
 11  /

LPAD('-',LVL,'-')||'>'||T1.ENAME
--------------------------------------------------------------------------------
->KING
-->JONES
--->SCOTT
-->BLAKE
--->MARTIN

start with fk_spravid in (select from справочник)

select lpad('-',level,'-') || '>' || ename
  from 
  ( select unique empno, mgr, empno
      from emp
      start with deptno in (select deptno from dept)
      connect by empno = prior mgr
  )
  start with mgr is null
  connect by mgr = prior empno

start with fk_spravid in (select from справочник)

select lpad('-',level,'-') || '>' || ename
  from 
  ( select unique empno, mgr, empno
      from emp
      start with deptno in (select deptno from dept)
      connect by empno = prior mgr
  )
  start with mgr is null
  connect by mgr = prior empno

start with fk_spravid in (select from справочник)

start with fk_id in (select from справочник)

select lpad('-',level,'-') || '>' || ename 
  from 
  ( select unique empno, mgr, ename 
      from *emp
      start with deptno in (select deptno from dept)
      connect by empno = prior mgr
  ) 
  start with mgr is null
  connect by mgr = prior empno

select lpad('-',level,'-') || '>' || ename 
  from emp
  where empno in
  ( select empno
      from emp
      start with deptno in (select deptno from dept)
      connect by empno = prior mgr
  ) 
  start with mgr is null
  connect by mgr = prior empno