Home » SQL & PL/SQL » SQL & PL/SQL » Connect By Clause in sql
icon2.gif  Connect By Clause in sql [message #195282] Wed, 27 September 2006 15:23 Go to next message
Messages: 1
Registered: September 2006
Junior Member
Connect by clause does not work when we have circular reference or self-referential integrity constraints. IT says,
"connect by loop in user data"
Please let me know if we have any workaround for such situations in SQL.
Re: Connect By Clause in sql [message #195286 is a reply to message #195282] Wed, 27 September 2006 15:47 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The exception has to do with circular references. It is not related to self-referential integrity constraints.

Oracle 10G has the NOCYCLE parameter and the CONNECT_BY_ISCYCLE pseudocolumn to see which rows contain the loop.
Previous Topic: Fine Grain Access Control
Next Topic: Export SELECT output to text file
Goto Forum:

Current Time: Sat Oct 22 03:06:06 CDT 2016

Total time taken to generate the page: 0.12736 seconds