查出时间段内的每一天
select level,to_char(to_date('2013-01-01','yyyy-mm-dd')+level-1,'yyyy-mm-dd') as dat from dual
connect by level <=to_date('2013-01-18','yyyy-mm-dd')-to_date('2013-01-01','yyyy-mm-dd')+1
查出12个月
select decode('0'||level,'010','10','011','11','012','12','0'||level||'') as dat from dual connect by level <= 12
本文出自 “小浩” 博客,请务必保留此出处http://zhangchi.blog.51cto.com/5214280/1121614