When to use connect by and prior in Oracle?ĬONNECT BY: It specifies the relationship between parent rows and child rows of the hierarchy. In this case the CONNECT_BY_ISCYCLE function indicates which record is responsible for the cycle.
To simplify matters, the CONNECT BY NOCYCLE clause tells the database not to traverse cyclical hierarchies. How does the connect by NOCYCLE function work in Oracle? You can include the NOCYCLE keyword between the CONNECT BY keywords and the condition specification of the CONNECT BY clause to filter out any rows that would otherwise cause the hierarchical query to fail with error -26079 because of a cycle in an intermediate result set. Frequently Asked Questions What is the NOCYCLE keyword in CONNECT BY clause?
0 kommentar(er)
