Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Avoiding a Double Cursor...
Gary,
So long as you do the orderby in the inner query and then filter the rows in the outer querys everything works fine.
If there are new rows added between accessing different pages of data you will receive a different set of results - but that is probably the right thing todo anyway in this case. Received on Fri Sep 30 2005 - 07:17:04 CDT