Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> hierarchical queries
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