Home -> Usenet -> comp.databases.oracle -> preventing CONNECT BY from generating an error if cycles exist

preventing CONNECT BY from generating an error if cycles exist

From: Paul Rowe <paul_at_paulrowe.com>
Date: 1 Aug 2003 08:44:11 -0700
Message-ID: <bbd01c1e.0308010744.3dbc0a62_at_posting.google.com> 





Hello;



  I am wondering if anyone knows of a way to issue the CONNECT BY
clause on data that contains cycles?  I have a business requirement
that specifies that cycles could be present in the data and cannot be
prevented.  I want to use the CONNECT BY clause to prevent sending
massive IN clauses, but I cannot because CONNECT BY will generate an
error.  Is there a similar clause that I can use besides CONNECT BY?



Any help would be appreciated.



Sincerely,



paul_at_paulrowe.com
Received on Fri Aug 01 2003 - 17:44:11 CEST












Original text of this message