Re: I don't understand the results of my hierarchical query

From: kim <wykoffkb_at_yahoo.com>
Date: 20 Nov 2006 07:26:04 -0800
Message-ID: <1164036364.051868.304540@k70g2000cwa.googlegroups.com>

Maxim Demenko wrote:

> scott_at_ORA102> r
> 1 select RPAD(' ', 2*(LEVEL-1)) || ID ID, parent, LEVEL
> 2 from nodes
> 3 LEFT OUTER JOIN graph
> 4 ON id = CHILD
> 5 START WITH PARENT IS NULL
> 6* CONNECT BY PRIOR ID = parent
>
> ID PARENT LEVEL
> ---------- ---------- ----------
> 1 1
> 8 1 2
> 5 1
> 4 5 2
> 2 4 3
> 6 2 4
> 7 2 4
> 3 4 3
>
>
> Best regards
>
> Maxim

thanks, that works. Received on Mon Nov 20 2006 - 09:26:04 CST