Re: Issue with the order of data being retrieved from 10g.

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 29 May 2007 08:37:31 -0700
Message-ID: <1180453050.280501@bubbleator.drizzle.com>

neeraj.gupta1983_at_gmail.com wrote:

> as both the rows has value of 0(zero), the result should be shorted
> assending based on the
> rowid, but here its opposite, i.e. the result set is shorted
> descending for rowid.

The only way anything is sorted in Oracle is when you append ORDER BY to your query.

In the future post your DML and version.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue May 29 2007 - 10:37:31 CDT