Re: Children with multiple parents

From: joel garry <joel-garry_at_home.com>
Date: Fri, 2 Jan 2009 14:12:55 -0800 (PST)
Message-ID: <0756eaa4-e57d-48c4-8683-de070dc2a794_at_s9g2000prm.googlegroups.com>

On Jan 2, 1:01 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> Hi All,
>
> 10.2.0.4 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...
>
> DMX
>   DB1
>     APPSERVER1
>       APACHE1
>     APPSERVER2
>       APACHE1
>       APACHE2
>   DB2
>     APPSERVER2
>     APPSERVER3
>   DB3
>     APPSERVER1
>     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?
>
> Thanks,
>
> Steve

To my discredit, I don't know the answer to this, but I see some possibilities by this search on asktom:
SYS_CONNECT_BY_PATH "multiple parents"

jg

--
_at_home.com is bogus.
'"Running an app in a Web browser is like living without a penis."
I'm really not sure what this is supposed to mean, especially in light
of the fact that there are over three billion people on this planet
who live without penises (they're called "women", in case you haven't
heard of them), and by and large, they seem to do OK.' - Hippo Pot de
Mousse
'They usually just get a penis when they want one, I guess that would
be "on demand" ;-) ' - Anonymous
- http://www.infoworld.com/article/08/06/24/26FE-microsoft-gates-plus_2.html

Received on Fri Jan 02 2009 - 16:12:55 CST