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: oracle_doc <nilendu_at_nilendu.com>
Date: 18 Feb 2006 01:37:56 -0800
Message-ID: <1140255476.221077.203740@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? Received on Sat Feb 18 2006 - 03:37:56 CST

Original text of this message

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