Q
Problem solve Get help with specific problems with your technologies, process and projects.

Getting data in different order in 10g vs. 8i

Is there any difference in selecting data from Oracle 8i and Oracle 10g? Because in Oracle 10g I'm getting data in a different order. Note: I never used order by clause in either case.

Is there any difference in selecting data from Oracle 8i and Oracle 10g? Because in Oracle 10g I'm getting data in a different order. Note: I never used the order by clause in either case.
In relational database theory, you are not guaranteed any order. Rows are part of a set and by definition, there is no ordering in a set. If you need a guaranteed order, then you must use the ORDER BY clause. Just because you received the data in a specific order in the past does not guarantee that you will always get that order in the future -- unless you use the ORDER BY clause.

Dig Deeper on Oracle DBA jobs, training and certification

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close