• SELECT - Spalten oder Ausdrücke
• FROM - Tabelle(n) oder View(s)
• WHERE - Zeilen auswählen
• CONNECTED BY PRIOR - Baumstruktur
• START WITH - Wurzel des Baumes
• ORDER BY - Sortierun

SELECT LPAD(' ', (LEVEL*3)) || ename || ' - ' || job "ORGANIGRAMM"

FROM emp

CONNECTED BY PRIOR empno = mgr

START WITH ename = 'KING'

ORDER BY LEVEL;

"ORGANIGRAMM"

KING - PRESIDENT

      JONES - MANAGER

      BLAKE - MANAGER

      SCOTT - ANALYST

      WARD - SALESMAN

      MILLER - CLERK

         ADAMS - CLERK

         SMITH - CLERK