Originally Posted by
mahajanakhil198
this requires changing the coding of all forma and reports of my application dat i cant afford..Is there any way or parameter setting that allows implicit order by alongwith group by??
No, there isn't. Implicit ORDER BY with GROUP BY is a myth.
Quote from 9i docs:
http://download.oracle.com/docs/cd/B...3a.htm#2066158
The GROUP BY clause groups rows but does not guarantee the order of the result set. To order the groupings, use the ORDER BY clause.
Obviously, omitting the ORDER BY was a developer mistake. If you want sorted output you have to sort it explicitly. It apply to queries with GROUP BY or without it.
Changing the optimizer_features_enable is the only thing that might help. I hope it gives you enough time to adjust the queries.
Perhaps others here have some idea ...
Good luck.
Ales
The whole difference between a little boy and an adult man is the price of toys
Reply With Quote