Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Pls Help... Oracle sort order
Michel Cadot wrote:
> "DA Morgan" <damorgan_at_psoug.org> a écrit dans le message de news: 1183755034.557325_at_bubbleator.drizzle.com...
> | Amritha.Datta_at_gmail.com wrote:
> | > 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.
> |
> | In whatever order it happens to find them depending on the path it
> | chooses to read them.
> |
> | Don't expect this to change depending on version.
> |
> | If you want to have ordering without an ORDER BY clause you must
> | use a sorted hash cluster or an Index Organized Table (IOT).
>
> Even in this case this is not true.
>
> For instance,
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:74320098178823#74401237604050
>
>
> | --
> | 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
>
> Regards
> Michel Cadot
Thanks for catching that.
-- 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 Sat Jul 07 2007 - 08:38:21 CDT