Re: default select order
Date: Thu, 08 Jan 2009 09:04:29 GMT
database version is 10.2.0.1.0.
I'm going to fix this of course by adding the missing order by -clauses to the program, the problem is that I cannot deliver it very easily to the customer and that's why I was hoping to find some kind of work around that could be done in the database and would work even a little better for a week or two. I find this very interesting behaviour because it's different what I've used to in Oracle7.
Thanks for all the answers,
"Maija-Leena" <kangasmaki_at_netti.fi> wrote in message
> we have changed from Oracle 7 to Oracle10g2 and found a mistake from our
> program that didn't appear in the old environment.
> That is, we have two select-statements that should return rows in the same
> order but there is no order by -clause.
> Now I'm wondering why 10g2 works like this (every time I query)? What
> determines the order of the returned rows?
> SELECT X FROM TABLE_Z WHERE SOMETHING ='SOMETHING' ;
> SELECT Y FROM TABLE_Z WHERE SOMETHING='SOMETHING' ;
> Avoin (refers to A)
> Ei kaytossa (refers to E)
> Valmis (refers to V)
> If I change the first query to SELECT X,Y, then I get the same order than
> the last query. Column Y is not in primary key or any index. Is there a
> to fix this in the database ?
Received on Thu Jan 08 2009 - 03:04:29 CST