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;