CONNECT_BY_ISCYCLE

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::=

Connect_By_IScycle

Example

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