Oracle获取时间段内的各月底日期

select last_day(add_months(date'2019-07-01',rownum-1)) busi_dt
from dual
connect by rownum<=months_between(date'2020-05-31',date'2019-07-01')+1
order by busi_dt;

  

All for u
原文地址:https://www.cnblogs.com/ayumie/p/13494795.html