Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: preventing CONNECT BY from generating an error if cycles exist

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US