oracle怎样获取月份+天数并产生一张临时表

Question

如题所述

Answer 1

月份+天数 不就等于 月份+该月的最后一天吗？
select to_char(sysdate,'MMDD') from dual;

Answer 2

select extract(month from sysdate) from dual;
select extract(day from sysdate) from dual;