My Oracle Support Banner

Order of Data Retrieval Differs After Upgrading From 9i to a Higher Version (Doc ID 456707.1)

Last updated on MARCH 03, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.



Customers, Support

SQL output and the order of data

It is not uncommon for SQL in 10g or later, using the same execution plan as previously in 9i, to return the data in a different order for columns outside of the ORDER BY clause.

For example, the following output is from SQL with an ORDER BY NAME clause:

After an upgrade, this can cause issues with customers and applications which were reliant on the fixed order of SURNAME although it was not explicitly ordered.


Upgrade from 9.x to a higher version


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.