--动态生成树
select l, ei, lpad('|--' || n, length('|--' || n) + (l * 5 - 5), ' ')
from (select level l,
e.employee_id ei,
e.manager_id mi,
e.first_name || ' ' || e.last_name n
from employees e
start with e.manager_id is null
connect by prior e.employee_id = e.manager_id);
from (select level l,
e.employee_id ei,
e.manager_id mi,
e.first_name || ' ' || e.last_name n
from employees e
start with e.manager_id is null
connect by prior e.employee_id = e.manager_id);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25086534/viewspace-682458/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25086534/viewspace-682458/