Re: Hierarches

In Joe Selko's "SQL for Smarties", chapter 26 covers this. The method of using nested sets to represent the hierarchy works well and is fairly quick. I have used it in a couple of projects to manage a reporting hierarchy. It does take a small PL*SQL module to manage the hierarchy. This is a recursive module that updates the columns that is used to manage the nested sets.

HTH
   James

In article <3625f757.0_at_news>, "Mike Messeh" <mmesseh_at_perspect.com> wrote:

>Question: Does anyone out there know how to set up a hierarchy in ORACLE?
>What I am trying to do is create a hierarchy which could, in theory, go on
>infinitely between parent and children. Any help is appreciated greatly.
>Thanks.
>-Mike-

-- 
lorenzen_at_yuck.net             | Life is complex; it has
                              |   real and imaginary parts