All Friday's in a Current year

SELECT req_dates, TO_CHAR (req_dates, 'DY')

FROM (SELECT TRUNC (SYSDATE, 'YY')+ ( ROWNUM- 1) req_dates

FROM (SELECT 1 FROM DUAL GROUP BY CUBE (1, 2, 3, 4, 5, 6, 7, 8, 9))

WHERE ROWNUM <= 365)

WHERE TO_CHAR (req_dates, 'DY') IN ('FRI');