Schematically:
SELECT *
FROM TheTable
WHERE TheDate BETWEEN TO_DATE(CONCAT(TO_CHAR(sysdate, 'YYYY'), '-JUL-01'), 'YYYY-MON-DD')
AND TO_DATE(CONCAT(TO_CHAR(sysdate, 'YYYY'), '-JUL-31'), 'YYYY-MON-DD') + 1 - (1 / (24 * 60 * 60))
Built from
sql - oracle date range - Stack Overflow[
^]