查出区间整数

oracle下，利用dual表创建

with ct (id)
as 
(
select 1 as id from dual
union all 
select id+1 from ct where id <100
)
select id from ct

或者用临时表循环插入

或者用现有的物理表的rownum