Re: cannot have subqueries in CONNECT BY clause

timkarnold doodled thusly:

>from Thomas Kyte
>
>another thing missing from the press releases ;)
>
>
>in 9i:
>
>
>so, in addition to ORDER SIBLINGS BY to order a hierarchy and the
>sys_connect_by_path to get the trail back to your root of the hirearchy, you
>can
>JOIN with connect by.
>

Oh you BEAUTY!!!!!!!

Thanx, Tim!

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Tue Nov 20 2001 - 07:54:51 CST