Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to implement link list

Re: How to implement link list

From: Allen Kirby <akirby_at_att.com>
Date: 1997/01/08
Message-ID: <32D3C43D.58E4@att.com>#1/1

John Verbil wrote:

>
> Not at all, if you use START WITH and CONNECT BY.
>

I thought of that, but since I hadn't used it before I didn't think it would do what your example shows. Obviously this is the way to go.

> The table used as an example could stand a bit of normalizing, so I'll
> start fresh, and use a forward pointer only. If Ho needs a
> doubly-linked list, extending this is pretty simple.

If you're speaking about the table I used as an example, I thought it was normalized. Since this is not a 1->Many recursive relationship (it is exactly 1->2 and 2 is a fixed number), then I don't think you can really call it a repeating group. Just out of curiousity, how would you modify the table to make it normalized? Then again, maybe we're not talking about the same example.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.
Received on Wed Jan 08 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US