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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
| select *   from
|   ( select t1.*, rownum rn from ( select * from t1 order by x ) t1
|      where rownum <= upper_limit )
|  where rn >= lower_limit;
|
|
| "¢Ð¢ý¢ö" <@.@> wrote in message
news:[EMAIL PROTECTED]
| > 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
| >
| >
|
|