Friday, August 7, 2009

Connect by nocycle Query - Wrong results

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;
alter session set optimizer_features_enable=''

You can see this issue on,,

Satishbabu Gunukula

1 comment: