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

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 Received on Tue May 29 2007 - 10:10:37 CDT