Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> hierarchical queries

hierarchical queries

From: T <t_at_yahoo.com>
Date: Wed, 26 Oct 2005 13:39:53 +0200
Message-ID: <djnpul$1vc$1@ss405.t-com.hr>


I have problem with hierarchical query on Oracle database 9.2. I need to list (with SQL-plus) all child at leaf level for each parent on root level ....

Example

PARENT         CHILD
A1                    1
A1                    2
A1                    3
A2                    4
A3                    5
A4                    A1
A4                    A2
A5                    A2
A5                    A3



output
PARENT        CHILD
A1                    1
A1                    2
A1                    3
A2                    4
A3                    5
A4                    1
A4                    2
A4                    3
A4                    4
A5                    4
A5                    5

I used "select .....from ....start with ..connect by prior....." but with no success..

Every help is welcome!!!
 :)) Received on Wed Oct 26 2005 - 06:39:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US