Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A hierarchical query - how do I do
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