Ascetic
Last Activity: Mar 17 '14, 01:34 PM
Joined: Jan 13 '14
Location:
-
Solved by using CONNECT_BY_ISCY CLE pseudocolumn and transaction rollback -
Now to prevent cycle creating in hierarchical data
Hi!
I use query with CONNECT BY to select hierarchical data.
After I created cycle in data tree I have error:ORA-01436: CONNECT BY loop in user data.
How can I prevent cycle creating?
No activity results to display
Leave a comment: