Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what do you mean by CONNECT BY NOCYCLE

840912Apr 28 2011 — edited Apr 29 2011
hi,
can any body tell me what do you mean by CONNECT BY NOCYCLE


SELECT col1, LEVEL
FROM temp
START WITH col2 = 2091799838
CONNECT BY NOCYCLE col2 = PRIOR col1
ORDER BY LEVEL DESC
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2011
Added on Apr 28 2011
3 comments
15,476 views