Find All Sundays In a Month of Input Date

WITH T AS
(
SELECT TO_DATE(TO_CHAR(SYSDATE,'MON-YYYY'),'MON-YYYY')+LEVEL-1 DT FROM DUAL
  CONNECT BY LEVEL < ADD_MONTHS(to_date(TO_CHAR(SYSDATE,'MON-YYYY'),'MON-YYYY'),1) - to_date(TO_CHAR(SYSDATE,'MON-YYYY'),'MON-YYYY') + 1
)
SELECT DT FROM T WHERE
TRIM(TO_CHAR(DT,'DAY')) = 'SUNDAY';