用SQL取到本月为止的今年所有月份

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

select lpad(rownum - 0, 2, 0) ymd
  from dual
connect by rownum <= substr('20101130', 5, 2)