oracle创造亿级别数据过程

create table EMP
(
EMPNO NUMBER(8) PRIMARY KEY,
ENAME VARCHAR2(20),
MGR NUMBER(20),
HIREDATE DATE
);

create table che
(
id NUMBER(8) PRIMARY KEY,
name VARCHAR2(20),
HIREDATE DATE
);

 
declare
i integer;
begin
i := 1;
loop
insert into che (id,name,HIREDATE)
values
(i,
'苏F 00001',
SYSDATE);
i := i + 1;
exit when i > 200000;
end loop;
commit;
end;

 

 

 

 

 

create table datatemp
(
gmsfhm NUMBER(18) PRIMARY KEY,
name VARCHAR2(20),
sex VARCHAR2(20),
birthday VARCHAR2(20),
lxdh  VARCHAR2(20)
);

declare
i integer;
begin
i := 1;
loop
insert into datatemp (gmsfhm,name,sex,birthday,lxdh)
values
(320602+i,
'小拾',
'男',
'2019-07-25',
'14712345678');
i := i + 1;
exit when i > 500000;
end loop;
commit;
end;

create table house 
(
gmsfhm NUMBER(8) PRIMARY KEY,
name VARCHAR2(20),
FWMJ VARCHAR2(20),
address VARCHAR2(50),
lxdh  VARCHAR2(20)
);

declare
i integer;
begin
i := 1;
loop
insert into house (gmsfhm,name,FWMJ,address,lxdh)
values
(320602+i,
'小拾',
'98',
'北京市x区x小区',
'14712345678');
i := i + 1;
exit when i > 100000;
end loop;
commit;
end;

create table che
(
gmsfhm NUMBER(18) PRIMARY KEY,
name VARCHAR2(20),
chepai VARCHAR2(20),
color VARCHAR2(20),
lxdh VARCHAR2(20)
);

declare
i integer;
begin
i := 1;
loop
insert into che (gmsfhm,name,chepai,color,lxdh)
values
(320602+i,
'小拾',
'苏F0555A',
'黑色',
'14712345678');
i := i + 1;
exit when i > 500000;
end loop;
commit;
end;