RE: SELECT Output Default Ordering ?

The official answer is, however the database feels like doing it at the time.

In practice, it depends on the access method. If an index is used the output may be sorted by that index. Otherwise it might be by rowid. There are no guarantees and no defaults. Relational data has no default order.

> -----Original Message-----
> From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 9:33 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SELECT Output Default Ordering ?
>
>
>
> When NOT Giving any Order by Clause , How is the Output of
> the SELECT Clause ordered by Default ?
> Assuming There exists a Unique index on the Table
>
> Is some Rule followed ?
>
> NOTE Records may have been INSERTED into the Table in some
> manner differing
> from the Order of the data of the Unique index Key fields.
>
> Thanks
>

LEGAL NOTICE:
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sarnowski, Chris
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).