Re: order by clause in cursors?

From: <>
Date: 1997/05/30
Message-ID: <>#1/1

In article <5mhq8m$akf$>, (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.

-------------------==== Posted via Deja News ====-----------------------     Search, Read, Post to Usenet
Received on Fri May 30 1997 - 00:00:00 CEST

Original text of this message