Re: Pls Help... Oracle sort order

"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 Received on Sat Jul 07 2007 - 01:10:33 CDT