Re: Pls Help... Oracle sort order

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).

-- 
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