Skip to Main Content
Forums

Oracle Database Discussions

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!

Is it mandatory to use PRIOR in CONNECT BY NOCYCLE in Oracle 10.2.0.4

MahipalAug 7 2009 — edited Aug 12 2009
Hi,

Is it mandatory to use PRIOR in CONNECT BY NOCYCLE in Oracle 10.2.0.4.

While I am executing a query in 10.2.0.2 which is having CONNECT BY NOCYCLE and PRIOR is not included, it was executing fine.

But in 10.2.0.4 If i run the same query without using PRIOR in CONNECT BY NOCYCLE, it is running indefinitely.

If I add PRIOR in CONNECT BY NOCYCLE then it is executing successfully.

So I want to know is it mandatory to add PRIOR in CONNECT BY NOCYCLE from 10.2.0.4 onwards.

If Yes, can you please provide any support documents for that.

Thanks,
Mahipal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2009
Added on Aug 7 2009
#general-database-discussions
6 comments
1,108 views