From: mcstockspamplug@spamdamenquery.com   
      
   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"  wrote in message   
   news:Vppvb.202877$275.751945@attbi_s53...   
   | 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:bpc5i8$khq10@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   
   | >   
   | >   
   |   
   |   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)