Q:

Oracle 11g fetch values using offset value

I am trying to fetch set of records from the database part by part.
I tried to use Limit and fetch but it seems like it does not working with oracle 11g. Is there any alternative solution to do this. I have tried many in google results but nothing is working properly. 

A:

You can use this query and do what u want. 
  SELECT A.*
  FROM (SELECT A.*, ROWNUM ROWNUMBER
          FROM Table1 T
         WHERE ROWNUM <= TO) T
  WHERE ROWNUMBER > FROM;

FROM is from which number and TO is to which number 

