Information retrieval in parent-child hierachy
From: konghou <brotherhou_at_yahoo.com>
Date: 7 Jun 2002 02:11:55 -0700
Message-ID: <c19678a1.0206070111.15469417_at_posting.google.com>
Date: 7 Jun 2002 02:11:55 -0700
Message-ID: <c19678a1.0206070111.15469417_at_posting.google.com>
In a parent-child hierachy (e.g. emp table in demo) it is possible to
retrieve information of children using connect by. How to retrieve
information of parents? Is it possible to retrieve information of
upper/lower/same levels of any node on the tree? Consider the
following cases:
i) depth of tree is known;
ii) depth of tree is unknown;.
Received on Fri Jun 07 2002 - 11:11:55 CEST