Re: Hierarchy -- walk up as well as down?

From: JRStern <JRStern_at_gte.net>
Date: Tue, 19 May 1998 04:07:50 GMT
Message-ID: <6jr0h3$pm3$3@gte2.gte.net>

Yes, yes, ... I realized that about the time my car hit the freeway on the way home. Still, thank you.

Joshua Stern
JRStern_at_gte.net

On 19 May 1998 01:52:55 GMT, Phil Herring <revdoc_at_uow.edu.au> wrote:
>In article <3560e1b0.32713289_at_news1.occa.home.net> JRStern, JRStern_at_primalsys.com writes:
>>The start with / connect by prior works great, walking down the
>>hierarchy. Is it possible to walk up a hierarchy -- given a node, to
>>walk up and get all the parents? I mean, efficiently?
>
>You do this by moving the "prior" keyword to the other column in your
>CONNECT BY. As for efficiency, that depends on your indexes... make sure
>that you have both parent and child columns indexed appropriately.
>
>
>---------------------------------------------------------------------------
>Copyright 1998 Phil Herring. This article may not be reproduced for profit.
>---------------------------------------------------------------------------
Received on Mon May 18 1998 - 23:07:50 CDT