Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Default Query Result Ordering Details

Re: Default Query Result Ordering Details

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Mar 2007 19:13:26 -0800
Message-ID: <1172891606.980963@bubbleator.drizzle.com>


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.org
Received on Fri Mar 02 2007 - 21:13:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US