On Apr 11, 6:15 pm, "joel garry" <joel-ga..._at_home.com> wrote:
> On Apr 11, 1:24 pm, "Ben" <bal..._at_comcast.net> wrote:
>
> > 9.2.0.5 EntEd AIX5L
>
> > If I have a read-only table and issue a select statment with no order
> > by clause, will the data be returned in the same order every time?
>
> http://jonathanlewis.wordpress.com/2007/03/05/ordering/
>
> jg
> --
> @home.com is bogus.http://volokh.com/posts/chain_1176127892.shtml
Sorry, I guess I was kind of beating about the bush, I really was just
wondering how oracle sorts by default with no order by clause when
selecting from one table. I thought maybe rowid or primary key but I
tried both it seemed like neither was the answer. I'm not trying to
rely on not using an order by, but the question was asked of me by a
user and I just didn't really know. I probably should but the thought
never really crossed my mind because of the order by.
Received on Wed Apr 11 2007 - 20:01:15 CDT
