Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!news.tele.dk!news.tele.dk!small.news.tele.dk!tiscali!newsfeed1.ip.tiscali.net!proxad.net!feeder1-2.proxad.net!cleanfeed3-a.proxad.net!nnrp9-2.free.fr!not-for-mail From: "Michel Cadot" Newsgroups: comp.databases.oracle.misc References: <1183754310.302255.136000@r34g2000hsd.googlegroups.com> <1183755034.557325@bubbleator.drizzle.com> Subject: Re: Pls Help... Oracle sort order Date: Sat, 7 Jul 2007 08:10:33 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 Lines: 37 Message-ID: <468f2e58$0$2775$426a34cc@news.free.fr> Organization: Guest of ProXad - France NNTP-Posting-Date: 07 Jul 2007 08:10:32 MEST NNTP-Posting-Host: 82.67.171.166 X-Trace: 1183788632 news-4.free.fr 2775 82.67.171.166:2363 X-Complaints-To: abuse@proxad.net Xref: usenetserver.com comp.databases.oracle.misc:248749 X-Received-Date: Sat, 07 Jul 2007 02:10:33 EDT (text.usenetserver.com) "DA Morgan" a écrit dans le message de news: 1183755034.557325@bubbleator.drizzle.com... | Amritha.Datta@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@x.washington.edu (replace x with u to respond) | Puget Sound Oracle Users Group | www.psoug.org Regards Michel Cadot