oracle值建立一千万测试数据

建表

create table RYXX

(
  xm   VARCHAR2(20),
  csrq DATE,
  djrq DATE,
  hb   NUMBER

)

循环插入一千万条数据

declare
 maxnumber constant int:=10000000;
 i int:=1;
 begin
   for i in 1..maxnumber loop
     insert into RYXX
     values('cd'||(round(dbms_random.value(1,1000),0)),to_date('1990-01-01','yyyy-mm-dd'),to_date('2014-08-08','yyyy-mm-dd'),i);
     end loop;
     commit;
     end;

查询语句示例

select *from RYXX;
select * from RYXX where xm='asd'; 
select * from RYXX where xm like '%d%';
select * from RYXX where to_char(CSRQ,'yyyydd')='198719';
//insert into emp values(14,'dsssa','jj',1,to_date('1982-11-11','yyyy-mm-dd'),50,30,20);