Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!n59g2000hsh.googlegroups.com!not-for-mail
From: "Ben" <balvey@comcast.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: odd ( to me ) question
Date: 11 Apr 2007 18:01:15 -0700
Organization: http://groups.google.com
Lines: 26
Message-ID: <1176339675.188623.205470@n59g2000hsh.googlegroups.com>
References: <1176323068.759806.297880@n76g2000hsh.googlegroups.com>
   <1176329705.756794.236170@n76g2000hsh.googlegroups.com>
NNTP-Posting-Host: 71.236.40.220
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1176339675 5597 127.0.0.1 (12 Apr 2007 01:01:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 12 Apr 2007 01:01:15 +0000 (UTC)
In-Reply-To: <1176329705.756794.236170@n76g2000hsh.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: n59g2000hsh.googlegroups.com; posting-host=71.236.40.220;
   posting-account=duiEeQ0AAABalp98St1Q9Dh1_FegSxci
Xref: news.f.de.plusline.net comp.databases.oracle.server:196257

On Apr 11, 6:15 pm, "joel garry" <joel-ga...@home.com> wrote:
> On Apr 11, 1:24 pm, "Ben" <bal...@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.