If you can't find any predicate
that will break the cycle and add it to
the CONNECT BY clause, then I'm afraid
the solution is recursive PL/SQL...
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Paul Rowe" <paul_at_paulrowe.com> wrote in message news:bbd01c1e.0308010744.3dbc0a62_at_posting.google.com...
> 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?
Received on Fri Aug 01 2003 - 18:52:10 CDT
