在oracle中自动大批量生成测试数据

方法1：
SQL> create table b as select 1 id from dual connect by level<=100;

方法2：

SQL> create table a (id int);

Table created.

SQL> insert into a select 1 from dual connect by level<=100;  

100 rows created.


方法三：

create table test_big as select * from all_objects;
insert into test_big as select * from test_big ;
insert into test_big as select * from test_big ;
insert into test_big as select * from test_big ;
insert into test_big as select * from test_big ;

方法四：

create table big_table(a int,b char(3));
declare
i int;
begin
for i in 1..10000 loop
insert /*+ append */ into big_table nologging values(i,'sex');
if mod(i,1000)=0 then
commit;
end if;
end loop;
end;

 

PLSQL Develope手册上的说明，供参考&#x