Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to implement link list
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
![]() |
![]() |