SELECT last_name||' reports to '|| PRIOR last_name
&quot;manager_and_worker&quot;, level
FROM employees
WHERE level = 2
START WITH employee_id = 100
CONNECT BY PRIOR employee_id = manager_id
manager_and_worker LEVEL
------------------------------ ----------
Kochhar reports to King 2
De Haan reports to King 2
Raphaely reports to King 2
Weiss reports to King 2
Fripp reports to King 2
Kaufling reports to King 2
Vollman reports to King 2
Mourgos reports to King 2
Russell reports to King 2
Partners reports to King 2
Errazuriz reports to King 2
...