Children with multiple parents

From: Steve Howard <>
Date: Fri, 2 Jan 2009 13:01:56 -0800 (PST)
Message-ID: <>

Hi All, 64 bit Enterprise on SuSE 2.6.16

I have been working on a small application to allow us to print a hierarchical list of affected systems when a change is made to another system. For example, when a change is made to our storage system, we want a report that may look like the following...



    DB2 (database link)

I have been struggling to get this to work with a connect by prior structure. I ended up writing a pipelined table function that provides what we need, but I am fairly sure it is not the best way to do this.

Before I spend my weekend spinning my wheels, can anyone comment as to whether model where multiple children can be related to multiple parents (and vice versa) can be handled by connect by prior? If not, is there a better way that jumps out at you?


Steve Received on Fri Jan 02 2009 - 15:01:56 CST

Original text of this message