This is an old revision of the document!
select level, lpad('-', level*2-2, '=') as position, employee_id as emp_id, last_name as emp_name, prior employee_id as man_id, prior last_name as man_name, salary - prior salary as diff from employees --where salary - prior salary > 0 connect by prior employee_id = manager_id start with employee_id = 100
ast abschneiden
select level, lpad('-', level*2-2, '=') as position, employee_id as emp_id, last_name as emp_name, prior employee_id as man_id, prior last_name as man_name, salary - prior salary as diff from employees --where salary - prior salary > 0 -- where prior employee_id != 108 connect by prior employee_id = manager_id and employee_id != 108 start with employee_id = 101