select 2016 iyear, to_number(to_char(add_months(trunc(to_date(2016,'yyyy'),'yyyy'),level-1),'mm')) imonth from dual connect by level<=12
转载于:https://my.oschina.net/wxh1989/blog/726461
select 2016 iyear, to_number(to_char(add_months(trunc(to_date(2016,'yyyy'),'yyyy'),level-1),'mm')) imonth from dual connect by level<=12
转载于:https://my.oschina.net/wxh1989/blog/726461