Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tree structure
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 Wed Feb 25 1998 - 00:00:00 CST