Task Hierarchical Retrieval Solutions

http://dedyrw.staff.telkomuniversity.ac.id/2014/05/13/task-hierarchical-retrieval/

Nama : Shinta Devi lestari (6301120239)
Kelas: DBD-12-01

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.manager_id is 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 (d.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;

Just another Telkom University Student Blog site