Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tree structure
Is it an extended SQL or you have to do it thru store proc or some kind of languages.
Thanks
Gary England wrote:
>
> Oracle has a ... CONNECT BY PREVIOUS ... START WITH ... clause that
> defines the parent/child relationships of columns with a single table.
> It must be a single table select... no joins or views.
>
> ªü¼Ö¥K wrote:
> >
> > Hi,
> > Does anyone know how to implement a tree data structure into RDBMS ?
> > and provide a grouping
> > query for any note within the tree.
> > e.g.
> > a
> > / \
> > b c
> > / \ / \
> > e f g h
> > ... ... ... ...
> > query for group b will included e, f ... etc.
> > thanks in advice.
> >
> > arnox,
> > 8-)
Received on Thu Feb 26 1998 - 00:00:00 CST