[SQL] How to fetch first record with special condition after chosen record in Oracle query?

please help. I have query which shows many records. I need to find way how to for example: After record with value 'A' fetch first 3 records

Thank you

CREATE TABLE "TABLETEST"
(
"CUSTOMER_ID" NUMBER,
"VALUE" VARCHAR2(255 BYTE)
)


INSERT INTO TABLETEST VALUES (1, 'valueb');
INSERT INTO TABLETEST VALUES (2, 'valuec');
INSERT INTO TABLETEST VALUES (3, 'valuea');
INSERT INTO TABLETEST VALUES (4, 'valueD');
INSERT INTO TABLETEST VALUES (5, 'valueF');
INSERT INTO TABLETEST VALUES (6, 'valueY');
INSERT INTO TABLETEST VALUES (7, 'valueU');
INSERT INTO TABLETEST VALUES (8, 'valueaT');

I would like to see 3 records after record customer_id= 5

Continue reading...