Whether they are called hierarchical structures, trees, or self-referencing tables they often pose quite a challenge to traverse in any simple manner. But Oracle has a solution.
This story continues at
http://dbasupport.com/oracle/ora10g/JustSQL07.shtml
