Purpose
For a CONNECT BY query, this function returns whether a row causes a cycle. For more information, refer to the description of the SELECT statement in the Query language (DQL) section.
Syntax
connect_by_iscycle::=
Example
Copy
SELECT CONNECT_BY_ISCYCLE,
SYS_CONNECT_BY_PATH(last_name, '/') "PATH"
FROM employees WHERE last_name = 'Clark'
CONNECT BY NOCYCLE PRIOR employee_id = manager_id
START WITH last_name = 'Clark';Result
| CONNECT_BY_ISCYCLE | PATH |
| 0 | /Clark |
| 1 | /Clark/Jackson/Johnson/Clark |
