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.

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

This message: [ Message body ]
Next message: Paul Rowe: "PL/SQL Collections"
Previous message: Michael Shilokovsky: "Re: Oracle on Solaris-Intelx86?"
Next in thread: Paul Scott: "Re: preventing CONNECT BY from generating an error if cycles exist"
Reply: Paul Scott: "Re: preventing CONNECT BY from generating an error if cycles exist"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message