Re: OFFSET function in oracle

this question seems to pop up every few days

good solution, but don't forget to take a larger look at your application

if the user is paging thru a large set of records, consider some mechanism to pre-select the PKs for the entire set and then use these to fetch each page -- the performance trade off can come after only one or two pages. and depending on your development tool, you could keep one cursor for doing the PK fetches as needed, and use a second one for grabbing the current page of data

• mcs

"VC" <boston103_at_hotmail.com> wrote in message news:Vppvb.202877$275.751945_at_attbi_s53...
| select * from
| ( select t1.*, rownum rn from ( select * from t1 order by x ) t1
| where rownum <= upper_limit )
| where rn >= lower_limit;
|
|
| "¢Ð¢ý¢ö" <_at_.@> wrote in message

 news:bpc5i8$khq10_at_imsp212.netvigator.com...
| > I want to retrieve a range of record
| > such as retrieving 11th to 20th records from 10000 records
| > In SQL Server, i can use the "OFFSET" function.
| > so i wanna ask does Oracle provide any function similar to "OFFSET" in
 SQL
| > SERVER?
| >
| >
| >
| > Thanks in advance
| > Regards
| > Bun
| >
| >
|
|
Received on Fri Nov 21 2003 - 16:05:32 CET