Re: Avoiding a Double Cursor...
- From: "stephen O'D" <stephen.odonnell@xxxxxxxxx>
- Date: 30 Sep 2005 05:17:04 -0700
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.
.
- References:
- Avoiding a Double Cursor...
- From: redrobot5050
- Re: Avoiding a Double Cursor...
- From: stephen O'D
- Re: Avoiding a Double Cursor...
- From: GWood
- Avoiding a Double Cursor...
- Prev by Date: Re: xml -> dml (/ddl)
- Next by Date: Using Dataguard with HP San replication
- Previous by thread: Re: Avoiding a Double Cursor...
- Next by thread: long dynamic SQL statement (Pro*C)
- Index(es):