oracle实现连续数字的插入

oracle实现连续数字的插入

利用PL/SQL方法

create table t (x int);

begin
for i in 1..10 loop
  insert into t values(i);
 end loop;
 commit;
end;
/

使用connect by level/rownum实现连续数字的插入

insert into t select rownum from dual connect by level<=10;
或者
insert into t select rownum from dual connect by rownum<=10;