Oracle Behavior Differences Between Releases

Feb 6, 2017 4:25:07 PM by Dan Hotka

This is a companion discussion topic for the original entry at

The reason GROUP BY no longer resulted in a default sort in Oracle 10.2 is that Oracle started using a hash value for the grouping rather than the columns. Many people relied on that default sort and were upset with the change. Oracle documentation has always stated that no order is guaranteed unless the SQL contains an ORDER BY clause. Even their documentation prior to 10 stated this.