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?
