Re: defined order of records for SQL query without explicit instruction (order by)?
From: Thomas Kellerer <OTPXDAJCSJVU_at_spammotel.com>
Date: Thu, 13 Jan 2011 13:23:40 +0100
Message-ID: <8p896cFbu0U1_at_mid.individual.net>
Frank Bergemann, 13.01.2011 13:17:
> Can i rely on getting record from b, which have a certain value b.x,
> one after another?
No, never.
Date: Thu, 13 Jan 2011 13:23:40 +0100
Message-ID: <8p896cFbu0U1_at_mid.individual.net>
Frank Bergemann, 13.01.2011 13:17:
> Can i rely on getting record from b, which have a certain value b.x,
> one after another?
No, never.
> Or is (oracle) "allowed" to deliver results in undefined order here?
Yes.
> Because if oracle is free to deliver in any order it would require to
> use
>
> select a.x, b.z from table a, b
> where a.x = b,x
> order by b.x;
>
> Which i currently do - for safety reasons.
And is the *only* way to guarantee a specific order.
Thomas Received on Thu Jan 13 2011 - 06:23:40 CST