Re: order by clause in cursors?

In article <5mhq8m$akf$1_at_scapa.cs.ualberta.ca>,   kirill_at_cs.ualberta.ca (Kirill Richine) wrote:

> However, when I iterate through it, the rows are actually not ordered
> by column a.

It turns out that the problem here is not only with cursors. The rows are not sorted even if I issue this sql from the sqlplus command line.

The particular thing about this table is that it is on the remote database connected to with a link. The rows are not sorted.

However, when I login to that remote database, using the same Oracle account as the link uses, everything works fine, the rows are sorted.

Any ideas?
Thank you.
k&

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet