Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A hierarchical query - how do I do
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.comReceived on Sat Feb 18 2006 - 21:52:31 CST