Re: Opinion on recursive columns

From: <Haniff_at_cyberdude.com>
Date: Fri, 17 Nov 2000 00:05:52 GMT
Message-ID: <8v1sor$ari$1@nnrp1.deja.com>

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. Received on Thu Nov 16 2000 - 18:05:52 CST