Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL Query Treewalk Teaser
Hi Folks,
DB 8.1.7 on NT
I'm no newbie, but I'm having some issues figuring out which way to go about this one, and I'd appreciate some help...
I have a table structure as follows:
.---------.
| Identity |
'---------'
| | n n
i.e an identity can be related to many other identities, which can in turn be related to many other identities.
The relationship is not strictly hierarchical like the old emp manager example.
What I would like to get is the entire set of identities that have any relationships given a starting identity?
With Oracle, how can I tree walk the entire set of relationships and list the identities. I don't care about the level, just the related identities.
Many thanks in advance,
Mike Cretan Received on Mon Apr 29 2002 - 00:30:59 CDT