Oracle SQL-如何使用分页循环记录？

我正在使用一个Oracle数据库，其中有一个包含20条记录的表

CREATE TABLE MyTable (
    MY_RECORD_ID NUMBER PRIMARY KEY, 
    SOME_DATA_1 VARCHAR2(200), 
    SOME_DATA_2 VARCHAR2(200)
);

INSERT INTO MyTable VALUES (1, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (2, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (3, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (4, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (5, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (6, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (7, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (8, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (9, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (10, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (11, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (12, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (13, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (14, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (15, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (16, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (17, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (18, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (19, 'BLAH1', 'BLAH2');
INSERT INTO MyTable VALUES (20, 'BLAH1', 'BLAH2');

我想做的是遍历此表，一次基于该MY_RECORD_ID列选择5条记录。该OFFSET和FETCH命令似乎让我做到这一点：

SELECT * 
FROM MyTable 
ORDER BY MY_RECORD_ID 
OFFSET 0 ROWS -- start at the first row
FETCH NEXT 5 ROWS ONLY;

我想将上述语句插入循环中，以便可以对五行中的每一行执行数据操作（这样总共执行4次）。有没有办法使用存储过程来做到这一点？