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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 18 Feb 2006 15:29:09 GMT
Message-Id: <pan.2006.02.18.15.29.09.766165@sbcglobal.net>


On Sat, 18 Feb 2006 01:30:36 -0800, oracle_doc wrote:

> I want a resultset that would *not only* build the tree within TASKS
> table -- but sort it
> on PREDECESSOR - SUCCESSOR ID as well.

That is unnecessary information which results only in an overhead. Data model is bad.

-- 
http://www.mgogala.com
Received on Sat Feb 18 2006 - 09:29:09 CST

Original text of this message

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