Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tree structure

Re: Tree structure

From: Dominic Yip <bis_at_netvigator.com>
Date: 1998/02/26
Message-ID: <34F65AA9.1C1A@netvigator.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US