Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Avoiding a Double Cursor...

Re: Avoiding a Double Cursor...

From: stephen O'D <stephen.odonnell_at_gmail.com>
Date: 30 Sep 2005 05:17:04 -0700
Message-ID: <1128082624.585626.119440@g49g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US