直接上代码
select last_month + (level - 1)
from (select add_months(trunc(sysdate, 'mm'), -1) last_month,
trunc(sysdate, 'mm') m
from dual)
connect by level <= m - last_month;
直接上代码
select last_month + (level - 1)
from (select add_months(trunc(sysdate, 'mm'), -1) last_month,
trunc(sysdate, 'mm') m
from dual)
connect by level <= m - last_month;