Find m to n rows from table

Summary
If you want to find a specific range or rows from a table, lets say all records from 35 to 65 from table YOUR_QUERY

CREATE TABLE YOUR_QUERY (ID NUMBER(3), col1 VARCHAR2(30));

BEGIN
    FOR i IN 1..100 LOOP
      INSERT INTO YOUR_QUERY VALUES (i, 'ROW' || i);
    END LOOP;
    COMMIT;
  END;

execute the following

SELECT *
  FROM (SELECT A.*, ROWNUM rnum
          FROM (SELECT * FROM your_query) A
         WHERE ROWNUM <= 65 )
 WHERE rnum >= 35;