The queries using “Connect by nocycle” may give different results with different versions.
Please try below workaround.
Alter the session and run the query.
alter session set "_optimizer_connect_by_cost_based"=false;
OR
alter session set optimizer_features_enable='10.2.0.1'
You can see this issue on 10.2.0.4,11.1.0.6,11.1.0.7.
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/
Subscribe to:
Post Comments (Atom)
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
شركة نقل اثاث بنجران
ReplyDeleteشركة نقل اثاث بخميس مشيط
شركة نقل اثاث بابها