Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: hierarchical queries
T wrote:
> 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!!!
> :))
Post your actual SQL. This looks like homework and, whether it is or not, no one should just hand you the answer ... rather point you in the right direction.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Oct 26 2005 - 10:11:41 CDT
![]() |
![]() |