A personal blog of Christopher Wigginton; a nerd by nature, programming polyglot, cooking enthusiast and fermentation practitioner.
select last_day(to_date(to_char(months.month) || '/1/' ||
'mm/dd/yyyy')) as range_EOM
from (select rownum year from dual connect by level <= 2019) years,
(select rownum month from dual connect by level <= 12) months
where years.year >= 2000
and months.month >= 1