ReliDB

Oracle has changed the algorithm used to perform “select distinct” operations from 10gR1 and earlier version to 10gR2 and new versions. This has caught a lot of custom application and script writers by surprise, when they depended on the ordering of returned values from 10gR1 and earlier versions. The problem is caused by [...]

Posted on August 27th, 2009 under 11g, Oracle, Oracle 10g, SQL, oracle 9i. Tags: 10g, 10gR1, 10gR2, 9i, distinct, Oracle, order by, return, select distinct, sort. Comments: None