Help Hierarchical representation in Oracle 8

From: Pascal Vigant <pascal.vigant_at_tecsi.com>
Date: Fri, 12 Mar 1999 11:32:14 +0100
Message-ID: <7caql2$i2k$1@news.tecsi.com>

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 - 04:32:14 CST