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: Help Hierarchical representation in Oracle 8

Re: Help Hierarchical representation in Oracle 8

From: Nina Wiesemann <nw.th_at_rhein-main.net>
Date: Fri, 12 Mar 1999 23:14:38 +0100
Message-ID: <7cc09n$6ed$1@test7.ipf.de>


Try the CONNECT BY operator in your select statement.

N. Wiesemann



Im Beitrag <7caql2$i2k$1_at_news.tecsi.com>, "Pascal Vigant" <pascal.vigant_at_tecsi.com> schrieb:

>Is there an object for representing a hierarchical representation like that
>:
>
> A is father of B
> A is father of C
> C is father of D
>
>
>my solution is the creation of 2 TABLES , but it's too heavy !!:
>
>TABLE 1: NAME (unique)
>TABLE 2: FATHER_NAME, NAME
>
>and in TABLE2, i put theses datas in order to know if D is the child of A :
> FATHER CHILD
> A B
> A C
> C D
> A D generated
>automatically from the previous values
>
>help me ... to find a good an speedy solution
>
>Thanks all
>
>P. Vigant
>
>
Received on Fri Mar 12 1999 - 16:14:38 CST

Original text of this message

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