--1. by japan
select level n from dual connect by level <=10;

--2. by tomkyte
select rownum n from all_objects where rownum<=10;

--3.
select to_number(column_value) n from xmltable('1 to 10');

--4. model
select n
  from (select 1 v from dual)
model
dimension by (v)
measures (v n)
rules
(
   n[for v from 2 to 10 increment 1] = n[cv(v)-1] + 1
);

--5. recursive with
with t(n) as
(
  select 1 from dual
  union all
  select n + 1 from t where n < 10
)
select n from t

ITPub博客

2012-12-05 generate sequence

最新文章