User Tools

Site Tools


kurs:connect_by_prior

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
kurs:connect_by_prior [2014/09/10 21:22]
127.0.0.1 external edit
kurs:connect_by_prior [2019/05/23 15:00] (current)
admin
Line 66: Line 66:
 group by a.first_name,​ a.last_name,​ a.salary group by a.first_name,​ a.last_name,​ a.salary
 order by a.salary desc; order by a.salary desc;
 +</​code>​
 +
 +=== Hierchie in einer Zeile ===
 +<​code>​
 +select first_name || ' ' || last_name employee_name, ​      
 +      level, lpad('>',​ level * 3, '​*'​) p,
 +       ​sys_connect_by_path ( first_name || ' ' || last_name, '/'​) h
 +from employees e 
 +connect by prior employee_id = manager_id
 +start with employee_id = (select employee_id from employees where manager_id is null) -- = 100
 </​code>​ </​code>​
kurs/connect_by_prior.txt ยท Last modified: 2019/05/23 15:00 by admin