Re: Pls Help... Oracle sort order

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 6 Jul 2007 21:53:03 +0100
Message-ID: <MsednVLTGes5NhPbnZ2dnUVZ8qijnZ2d@bt.com>

<Amritha.Datta_at_gmail.com> wrote in message news:1183754401.260677.108060_at_g13g2000hsf.googlegroups.com...
> In which sort order does oracle display the records if there is no
> sort order specified in the SQL query?
>
> Is there any article which tells about this?
>
> My Oracle version is 9i
>
> Thanks.
>

Unless you specify the sort order with an order by clause, the output order is dependent on the execution path that the optimizer happens to pick to acquire the data - which means the order may vary from day to day.

There are many articles about this on the internet, for example:

.http://jonathanlewis.wordpress.com/2007/03/05/ordering/

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Fri Jul 06 2007 - 15:53:03 CDT