时间段? select date'2009-01-01'+rownum-1 date1 from dual connect by rownum<=date'2009-12-12'-date'2009-01-01'+1
dual就是个临时表。不过关键看你是需要什么样的功能了我们经常在csdn里做测试的数据就是用dual来做的呀。类似select 1 id, 'name1' name from dual union select 2 id, 'name2' name from dual union select 3 id, 'name3' name from dual union .....
select to_date('2009-09-01','yyyy-mm-dd')+rownum-1 date1 from dual connect by rownum <=to_date('2009-09-10','yyyy-mm-dd')-to_date('2009-09-01','yyyy-mm-dd')+1
select date'2009-01-01'+rownum-1 date1
from dual
connect by rownum<=date'2009-12-12'-date'2009-01-01'+1
union
select 2 id, 'name2' name from dual
union
select 3 id, 'name3' name from dual
union
.....
select to_date('2009-09-01','yyyy-mm-dd')+rownum-1 date1
from dual
connect by rownum <=to_date('2009-09-10','yyyy-mm-dd')-to_date('2009-09-01','yyyy-mm-dd')+1