【我分享】一个造百万数据的SQL

LorrieL

create table emp
partition by RANGE(deptno)
( partition PART01 values less than (50000),
partition PART02 values less than (100000),
partition PART03 values less than (300000),
partition PART04 values less than (500000),
partition PART05 values less than (7000000),
partition PARTMAX values less than (MAXVALUE) )
      tablespace Test
      
  as select
  level as empno,
  dbms_random.string('A',30) as ename,
  dbms_random.string('B',7) as job,
  sysdate - mod(level,100) as hire_date,
  dbms_random.value(1,1000) as comm, dbms_random.value(1,10000) as salary,
  mod(level,1000000)+1 as deptno
   from dual
   connect by level <= 1000000;