Re: defined order of records for SQL query without explicit instruction (order by)?

From: Thomas Kellerer <>
Date: Thu, 13 Jan 2011 13:23:40 +0100
Message-ID: <>

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?

> 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

Original text of this message