Re: hierarchical query - returning a treewalked subset

From: havardk <hrkristiansen007_at_hotmail.com>
Date: Thu, 08 Nov 2007 03:01:12 -0800
Message-ID: <1194519672.445028.275810@q5g2000prf.googlegroups.com>

"Start with" which returns more than one row works fine.

The example below is slow, but working :-)

select level, emp.*
from employees emp
start with emp.employee_id in (select emp2.employee_id

                               from   employees  emp2
                               where  emp2.first_name like 'Kevin%')

connect by prior emp.employee_id = emp.manager_id /

Havard Received on Thu Nov 08 2007 - 05:01:12 CST