order by clause in cursors?

Hi!

[Quoted] I am trying to declare a cursor in the following way:

cursor c is
select a
from b
order by a;
...

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

How can I do it, and what's wrong with what I am doing?

Thank you.
k& Received on Wed May 28 1997 - 00:00:00 CEST