Oracle Magazine, Jan/Feb 2018
Database Developer and DBA ETL The CONNECT_ BY_ ISCYCLE function allows the identification of which entries in the hierarchy are currently involved within a cyclic relationship It can be used when dealing with NOCYCLE in a CONNECT BY clause Listing 11 demonstrates these three pseudofunctions Code Listing 11 Three pseudofunctions that answer questions SQL select connect_ by_ root ename root 2 connect_ by_ isleaf leaf 3 connect_ by_ iscycle cyc 4 sys_ connect_ by_ path ename full 5 from emp 6 start with ename in KING DENNIS 7 connect by NOCYCLE prior empno mgr ORACLE MAGAZINE JANUARY FEBRUARY 2018 103 ROOT LEAF CYC FULL KING 0 0 KING KING 0 0 KING JONES KING 0 0 KING JONES SCOTT KING 1 0 KING JONES SCOTT ADAMS KING 0 0 KING JONES FORD KING 1 0 KING JONES FORD SMITH KING 0 0 KING BLAKE KING 1 1 KING BLAKE ALLEN KING 1 0 KING BLAKE WARD KING 1 0 KING BLAKE MARTIN
You must have JavaScript enabled to view digital editions.