Re: Ye old exploding parts problem....

RYoung wrote:
>
> -- I've been looking for an example I saw some time ago of the 'exploding
> parts' problem...how to get an organized 'dump' showing the heiarchy of
> parts for an item if all the parts for it and their part numbers are in the
> same table. It's a self join but I can't seem to remember how to put it
> together right......

  You can use PRIOR and CONNECT BY to show the hiearchy.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.