SELECT A
FROM (SELECT TRUNC(TRUNC(ADD_MONTHS(TRUNC(SYSDATE), ROWNUM - 1), ‘mm’),
‘d’) + 5 + 7 AS A,
ROWNUM - 1 AS RN
FROM DUAL
CONNECT BY ROWNUM <=
CEIL(MONTHS_BETWEEN(TO_DATE(‘2022-08-08’, ‘YYYY-MM-DD’),
TRUNC(SYSDATE))))
WHERE MOD(RN, 3) = 0;