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

http://blog.csdn.net/jaminwm/article/details/5666014

方法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.

 

方法一经常用到，特记录！