摘要： 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 或者用临时表循环插入 或者用现有的物理表的rown 阅读全文