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 -> Re: hierarchical queries

Re: hierarchical queries

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 26 Oct 2005 08:11:41 -0700
Message-ID: <1130339493.338966@yasure>


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

Original text of this message

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