Re: Opinion on recursive columns

From: Neef <Haniff_at_cyberdude.com>
Date: Fri, 17 Nov 2000 20:56:56 GMT
Message-ID: <8v462k$5sr$1@nnrp1.deja.com>

In article <8v442f$465$1_at_nnrp1.deja.com>, Alex Filonov <afilonov_at_pro-ns.net> wrote:
>
> Connect by works great. There are limitations, there is a workaround
> also. You can put connect by select statement into inline view, then
> join this view with other tables.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Alex, that's fine if you are using connect by to walk *down* the tree. Your start with condition is then something like "parent_key is null". Most of our overhead, however is walking *up* the tree. I don't believe there *is* a SQL statement, IMHO, that will show the ancestors of a set of nodes.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 17 2000 - 14:56:56 CST