Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: about hierarchical query
Erpa <Erpa_at_email.it> wrote in news:cmt01j$2h8$1_at_newsread.albacom.net:
> hi all,
> how can I write an hierarchical query to view all level of my tree, but
> only the branches end with leaves that satisfy some conditions?
>
>
> for example, this is my tree in my hierarchical table:
>
> A1 A2
> / \ / \
> / \ / \
> B1 B2 B3 B4
> / \ / \ / \ / \
> C1 C2 C3 C4 C5 C6 C7 C8
>
> if only C1, C5 and C6 satisfy some conditions i wish to have this result
> from my query:
>
> A1 A2
> / /
> / /
> B1 B3
> / / \
> C1 C5 C6
>
> level node
> --------- ---------
> 1 A1
> 2 B1
> 3 C1
> 1 A2
> 2 B3
> 3 C5
> 3 C6
>
> thanks for your help
> Paolo
>
CONNECT BY clause on SELECT Received on Wed Nov 10 2004 - 08:52:05 CST