Re: large tree

Hi,

i want to get the first 20 childs under node_0.1 and their children. so when i restrict the select with where I get all childs (thounds) instead of the childs of the selected childs

thanks
christian

JusungYang_at_yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0306070945.45718d73_at_posting.google.com>...
> christian.wiedemann_at_key-tec.de (christian wiedemann) wrote in message news:<cb92ccb8.0306061558.5b9ae678_at_posting.google.com>...
> > hi all,
> > i have an large tree like
> > -node_0
> > -node_0.1
> > -node_0.1.1
> > -node_0.1.1.1
> > -node_0.1.2
> > -node_0.1.2.1
> > -thounsand other nodes with childs
> >
> > so what i want is to get the first 20 nodes under node_0.1 and their
> > descendants orderd by an condition and restricted by an condition
> >
> > is there a way to do this?
> >
> > thanx
> > christian
>
> Assuming you are familiar with the ORACLE "connect by" clause, and you
> have the table/data designed to work with "connect by", it is just a
> matter of applying
> the <start with>, <order by> and <where> clause at the right place. If
> I understand what you want correctly, you would just
> 1. Get all the child nodes under node_0.1 (since you want sorting)
> with <start with>
> 2. Apply restrictions to 1 with <where> and sort them with <order by>
> 3. select the first 20 nodes from 2 with ROWNUM <21
>
>
> - Jusung Yang
Received on Sun Jun 08 2003 - 12:11:55 CDT