1. select last_name from employees where last_name != ‘Lorentz’start with
last_name = ‘Lorentz’ connect by prior manager_id=employee_id;
2. select e.last_name, e.salary, d.department_name from employees e join
departments d on (e.department_id=d.department_id) start with e.last_name =
‘Mourgos’ connect by prior e.employee_id=e.manager_id;
3.select e.last_name, e.employee_id, e.manager_id, d.department_name from
employees e join departments d on (e.department_id=d.department_id) where e.job_id != ‘IT_PROG’
start with e.manageris null connect by prior e.employee_id=e.manager_id and e.last_name != ‘De Haan’;
4. select e.last_name, e.employee_id, e.manager_id, d.department_name from
employees e join departments d on (e.department_id=d.department_id) where last_name !=
‘Chen’ start with e.manager_id=(select manager_id from employees where last_name=’Chen’)
connect by prior e.employee_id=e.manager_id;
5. select e.last_name, e.employee_id, e.manager_id, d.department_name, j.job_title from departments d
join employees e on (d.department_id=e.department_id) join jobs j on (e.job_id=j.job_id) where e.department_id=
(select department_id from employees where last_name=’Zlotkey’) start with e.manager_id=(select manager_id
from employees where last_name=’Zlotkey’) connect by prior e.employee_id=e.manager_id;
6. select e.last_name, e.employee_id, e.manager_id, d.department_id, j.job_title from jobs
j join employees e on (e.job_id=j.job_id) join departments d on (e.department_id=e.department_id) where
(d.department_id, j.job_id) = (select department_id, job_id from employees where last_name= ‘Vargas’) start with
e.manager_id=(select manager_id from employees where last_name = ‘Vargas’) connect by prior e.employee_id=e.manager_id;
http://dedyrw.staff.telkomuniversity.ac.id/2014/05/13/task-hierarchical-retrieval/