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: Sun, 19 Feb 2006 03:52:31 GMT
Message-Id: <pan.2006.02.19.03.52.30.973036@sbcglobal.net> 





On Sat, 18 Feb 2006 01:37:56 -0800, oracle_doc wrote:



> Is this doable through a single SQL?




You have a messed up data model. You have "predecessor" and "successor"
data in another table and you want to use connect by to compute them. That
contradicts the rules of good design and you have problems. Your problem
is a consequence of bad design. The sooner you get to grip with it, the
better.


-- 
http://www.mgogala.com


Received on Sat Feb 18 2006 - 21:52:31 CST












Original text of this message













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