Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Default Query Result Ordering Details
D. Robbins wrote:
> Is there any documentation available on the default query result
> ordering in the absence of an ORDER BY clause? I looked through the
> Oracle docs and could not find much. I do not plan to depend on this
> behavior but I am curious on how it works. Thank you.
Precisely what Serge said.
Any apparent ordering you see in any query lacking an ORDER BY clause is purely coincidental. If you don't have an ORDER BY clause ... it can change.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Mar 02 2007 - 21:13:26 CST
![]() |
![]() |