Connect By Clause in sql [message #195282] |
Wed, 27 September 2006 15:23  |
ykkspring
Messages: 1 Registered: September 2006
|
Junior Member |
|
|
Hi,
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.
Regards
Yogesh
|
|
|
Re: Connect By Clause in sql [message #195286 is a reply to message #195282] |
Wed, 27 September 2006 15:47  |
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.
|
|
|