Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 10g : problem order of row in a select request (Oracle 10g)
Oracle 10g : problem order of row in a select request [message #405532] Thu, 28 May 2009 05:01 Go to next message
fagesk
Messages: 1
Registered: May 2009
Junior Member
Hi,

I have a problem with the Oracle 10g that i don't have in Oracle 8i.

Our system adds rows by using trigger in only one table TT1 to trace all insert, update and delete. It's used to compare the result between two version of our program.

In Oracle 8g, the scenario was below :
1) Reload of database
2) Run our treatment with a old version
3) Extract rows of the table TT1

4) Reload of database
5) Run our treatment with a new version
6) Extract rows of the table TT1

We compare the extracts and we are no problem.

With the Oracle 10g and the same scenario, the extracts are a different order ????

Our request use to extrace data is below. There is not order by clause because we don't order by a column.

SELECT * from TT1

Any idea ?
Re: Oracle 10g : problem order of row in a select request [message #405534 is a reply to message #405532] Thu, 28 May 2009 05:05 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
If you don't specify an order by the order of the query result is by definition random. You can't rely on a specific order unless you specify an order by.


Re: Oracle 10g : problem order of row in a select request [message #405536 is a reply to message #405532] Thu, 28 May 2009 05:06 Go to previous message
cookiemonster
Messages: 12409
Registered: September 2008
Location: Rainy Manchester
Senior Member
That can happen.
You're lucky the order stayed consistent on 8i - there's absolutely no guarantee that it would.
If you want data in a consistent order you have to add an order by clause.
Previous Topic: Limitation in UTL_TCP Package
Next Topic: Deadlock
Goto Forum:
  


Current Time: Tue Dec 06 12:36:32 CST 2016

Total time taken to generate the page: 0.10907 seconds