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

On May 29, 5:10 pm, neeraj.gupta1..._at_gmail.com wrote:
> Hi
>
> My problem is:
>
> i have a table say POLICY with three columns A, B and C.
> table has two rows, with column C having value 0 for both rows.
>
> Now i am writing
>
> select * from POLICY order by C.
>
> 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.
>
> Is that an issue with the version of 10g server, i am using or Is it
> some settings of the oracle server?
>
> Thanks
> Neeraj

the result should be shorted
> assending based on the
> rowid,

Oracle has never stated this. You seem to make this up.

--
Sybrand Bakker
Senior Oracle DBA