If I am recalling correctly, it will come back in ROWID order without an
order by clause.


On Thu, 2005-01-27 at 10:14 -0600, Bunke Bill C. wrote:

> Technically, your query had no ORDER BY clause, so the result set can be in any order and the server would have done what was asked.
>
> Remember that while you may appear to see ordered results, without ORDER BY it is, in fact, strictly circumstantial.
>
> Also remember that although we as humans easily understand what DATE/DATETIME/TIMESTAMP represent (and can likewise instantly convert the text values shown in a query), a computer does not, and only sees what it is told. If you want the order to be date/time driven, you must exclude any data-formatting functions and simply use the internal date/time format for accurate results.
>
> HTH,
> Bill
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html

----------------------------------------------------------------
|Matthew W. Ball (Matt)
|Team Lead for Infrastructure and Reliability Group
|Endeavor Information Systems Inc.
|(e) [Email address protected]
|(p) 847-227-2678
|(f) 208-275-0869
|(u) http://www.endinfosys.com
--------------------------------------------------------------
It is inaccurate to say I hate everything.
I am strongly in favor of common sense,
common honesty, and common decency.
This makes me forever ineligible for public office.
-H.L. Mencken, writer, editor, and critic (1880-1956)
--------------------------------------------------------------

Oracle LazyDBA home page