Re: Opinion on recursive columns

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Fri, 17 Nov 2000 20:22:48 GMT
Message-ID: <8v442f$465$1@nnrp1.deja.com>

In article <8v1sor$ari$1_at_nnrp1.deja.com>, Haniff_at_cyberdude.com wrote:
> In article <8u9inv$sdq$1_at_nnrp1.deja.com>,
> tommychill_at_my-deja.com wrote:
> > Anyone have a preference about using or not using recursive columns?
> >
> > We have a hierarchy of groups that we need to represent in the DB. I
> > normally try to avoid recursive columns and just use a sub-group
table
> > but I'm wondering if its a good decision or not.
> >
> > anyone?
> >
> > thanx,
> >
> > t
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> I'm using a recursive structure to store organization charts. Due to
> the limitations of "start with...connect by", we are having a bear of a
> time writing queries against it.
>
> HTH
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

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. Received on Fri Nov 17 2000 - 14:22:48 CST