Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: large tree
Hi,
thanks for answer
my table is like
p_key parent_ID parent_sub_ID child_ID child_sub_ID
and my "where condition table and order by table" is like p_key name value
thanks christian
"Eric Parker" <eric.parker.spamless_at_virgin.net> wrote in message news:<WHhEa.2712$0d7.76669_at_newsfep4-glfd.server.ntli.net>...
> "christian wiedemann" <christian.wiedemann_at_key-tec.de> 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
>
> Hi christian,
>
> Are you asking for a table to be designed and the required query to be
> written
> or
> do you have already have the table designed ?
>
> If you already have the table + data please post the table structure and
> some sample data.
>
> eric
Received on Sun Jun 08 2003 - 11:49:19 CDT