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

Home -> Community -> Usenet -> c.d.o.server -> Re: A hierarchical query - how do I do

Re: A hierarchical query - how do I do

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 18 Feb 2006 10:56:10 +0100
Message-ID: <43f6ef3a$0$15535$636a55ce@news.free.fr>

"oracle_doc" <nilendu_at_nilendu.com> a écrit dans le message de news: 1140255476.221077.203740_at_f14g2000cwb.googlegroups.com...

| Actually, in the above example, I was wrong. The sorting on ID -
| PARENT_ID should happen in the reverse order,
|
| i.e.,
| (1)     children before parents (TASKS table)
| (2)     predecessors before successors  (TASK_PREDECESSORS table)
|
| So, the final dataset should look like -
|
| {b c a A}
|
| Is this doable through a single SQL?
|

I don't understand your example:
- c (5) is precedessor of b (3), so shouldn't this be { c b ... }?

Finally, can you post a complete (and consistent) example?

Regards
Michel Cadot Received on Sat Feb 18 2006 - 03:56:10 CST

Original text of this message

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