Re: order of rows when selecting from table of
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 16 Apr 2004 09:52:46 -0700
True, but this is not a physical table.
The same rules *may* not apply.
Jared
david wendelken <davewendelken@xxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
04/16/2004 05:44 AM
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
cc:
Subject: Re: order of rows when selecting from table of
Subject: Re: order of rows when selecting from table of
>Oracle being a wonderful and concerned corporation will only guarantee
>that you will get the data out of the table when the select and other
>clauses are correct.
When I took my first Oracle SQL class back in the 80's, Oracle guaranteed
that the order of the returned data (without an order by clause) was
"indeterminate", meaning that they guaranteed that you could not count on
any order from query to query.
So, use the order by clause if you want a specific order!
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
