Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: preventing CONNECT BY from generating an error if cycles exist
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