Re: preventing CONNECT BY from generating an error if cycles exist

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 01 Aug 2003 18:41:35 +0200
Message-ID: <e16livgig8bpq5u403errmj7o4b1gbr1ul@4ax.com>

On 1 Aug 2003 08:44:11 -0700, paul_at_paulrowe.com (Paul Rowe) wrote:

>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

There isn't. Looks like you are stuck

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Aug 01 2003 - 11:41:35 CDT