创建表的语句，以及插入数据（存储过程）

来源：互联网发布：网络教育2018招生时间编辑：程序博客网时间：2024/05/16 09:43

create table TEST04
(
id VARCHAR2(100),
a_id VARCHAR2(100),
a_name VARCHAR2(100),
a_gender VARCHAR2(100),
a_cardid VARCHAR2(100),
a_address VARCHAR2(100),
a_phonenum VARCHAR2(100),
a_company VARCHAR2(100),
a_lastcompany VARCHAR2(100),
a_leader VARCHAR2(100),
a_birthday VARCHAR2(100),
a_salary NUMBER(10,4),
a_schoole VARCHAR2(100),
a_skill VARCHAR2(100),
a_qqnumber VARCHAR2(100),
b_id VARCHAR2(100),
b_name VARCHAR2(100),
b_gender VARCHAR2(100),
b_cardid VARCHAR2(100),
b_address VARCHAR2(100),
b_phonenum VARCHAR2(100),
b_company VARCHAR2(100),
b_lastcompany VARCHAR2(100),
b_leader VARCHAR2(100),
b_birthday VARCHAR2(100),
b_salary NUMBER(10,4),
b_schoole VARCHAR2(100),
b_skill VARCHAR2(100),
b_qqnumber VARCHAR2(100),
c_id VARCHAR2(100),
c_name VARCHAR2(100),
c_gender VARCHAR2(100),
c_cardid VARCHAR2(100),
c_address VARCHAR2(100),
c_phonenum VARCHAR2(100),
c_company VARCHAR2(100),
c_lastcompany VARCHAR2(100),
c_leader VARCHAR2(100),
c_birthday VARCHAR2(100),
c_salary NUMBER(10,4),
c_schoole VARCHAR2(100),
c_skill VARCHAR2(100),
c_qqnumber VARCHAR2(100),
d_id VARCHAR2(100),
d_name VARCHAR2(100),
d_gender VARCHAR2(100),
d_cardid VARCHAR2(100),
d_address VARCHAR2(100),
d_phonenum VARCHAR2(100),
d_company VARCHAR2(100),
d_lastcompany VARCHAR2(100),
d_leader VARCHAR2(100),
d_birthday VARCHAR2(100),
d_salary NUMBER(10,4),
d_schoole VARCHAR2(100),
d_skill VARCHAR2(100),
d_qqnumber VARCHAR2(100),
e_id VARCHAR2(100),
e_name VARCHAR2(100),
e_gender VARCHAR2(100),
e_cardid VARCHAR2(100),
e_address VARCHAR2(100),
e_phonenum VARCHAR2(100),
e_company VARCHAR2(100),
e_lastcompany VARCHAR2(100),
e_leader VARCHAR2(100),
e_birthday VARCHAR2(100),
e_salary NUMBER(10,4),
e_schoole VARCHAR2(100),
e_skill VARCHAR2(100),
e_qqnumber VARCHAR2(100)
);

create or replace procedure proc_test04

is
v_count number;
begin
v_count:=1;
while v_count<60000 loop
insert into test04 (
ID
,A_ID
,A_NAME
,A_GENDER
,A_CARDID
,A_ADDRESS
,A_PHONENUM
,A_COMPANY
,A_LASTCOMPANY
,A_LEADER
,A_BIRTHDAY
,A_SALARY
,A_SCHOOLE
,A_SKILL
,A_QQNUMBER
,B_ID
,B_NAME
,B_GENDER
,B_CARDID
,B_ADDRESS
,B_PHONENUM
,B_COMPANY
,B_LASTCOMPANY
,B_LEADER
,B_BIRTHDAY
,B_SALARY
,B_SCHOOLE
,B_SKILL
,B_QQNUMBER
,C_ID
,C_NAME
,C_GENDER
,C_CARDID
,C_ADDRESS
,C_PHONENUM
,C_COMPANY
,C_LASTCOMPANY
,C_LEADER
,C_BIRTHDAY
,C_SALARY
,C_SCHOOLE
,C_SKILL
,C_QQNUMBER
,D_ID
,D_NAME
,D_GENDER
,D_CARDID
,D_ADDRESS
,D_PHONENUM
,D_COMPANY
,D_LASTCOMPANY
,D_LEADER
,D_BIRTHDAY
,D_SALARY
,D_SCHOOLE
,D_SKILL
,D_QQNUMBER
,E_ID
,E_NAME
,E_GENDER
,E_CARDID
,E_ADDRESS
,E_PHONENUM
,E_COMPANY
,E_LASTCOMPANY
,E_LEADER
,E_BIRTHDAY
,E_SALARY
,E_SCHOOLE
,E_SKILL
,E_QQNUMBER
)
VALUES(
v_count
,trim('A_ID') ||v_count
,trim('A_NAME ') ||v_count
,trim('A_GENDER ') ||v_count
,trim('A_CARDID ') ||v_count
,trim('A_ADDRESS ') ||v_count
,trim('A_PHONENUM ') ||v_count
,trim('A_COMPANY ') ||v_count
,trim('A_LASTCOMPANY ') ||v_count
,trim('A_LEADER ') ||v_count
,trim('A_BIRTHDAY ') ||v_count
,v_count
,trim('A_SCHOOLE ') ||v_count
,trim('A_SKILL ') ||v_count
,trim('A_QQNUMBER ') ||v_count
,trim('B_ID ') ||v_count
,trim('B_NAME ') ||v_count
,trim('B_GENDER ') ||v_count
,trim('B_CARDID ') ||v_count
,trim('B_ADDRESS ') ||v_count
,trim('B_PHONENUM ') ||v_count
,trim('B_COMPANY ') ||v_count
,trim('B_LASTCOMPANY ') ||v_count
,trim('B_LEADER ') ||v_count
,trim('B_BIRTHDAY ') ||v_count
,v_count
,trim('B_SCHOOLE ') ||v_count
,trim('B_SKILL ') ||v_count
,trim('B_QQNUMBER ') ||v_count
,trim('C_ID ') ||v_count
,trim('C_NAME ') ||v_count
,trim('C_GENDER ') ||v_count
,trim('C_CARDID ') ||v_count
,trim('C_ADDRESS ') ||v_count
,trim('C_PHONENUM ') ||v_count
,trim('C_COMPANY ') ||v_count
,trim('C_LASTCOMPANY ') ||v_count
,trim('C_LEADER ') ||v_count
,trim('C_BIRTHDAY ') ||v_count
,v_count
,trim('C_SCHOOLE ') ||v_count
,trim('C_SKILL ') ||v_count
,trim('C_QQNUMBER ') ||v_count
,trim('D_ID ') ||v_count
,trim('D_NAME ') ||v_count
,trim('D_GENDER ') ||v_count
,trim('D_CARDID ') ||v_count
,trim('D_ADDRESS ') ||v_count
,trim('D_PHONENUM ') ||v_count
,trim('D_COMPANY ') ||v_count
,trim('D_LASTCOMPANY ') ||v_count
,trim('D_LEADER ') ||v_count
,trim('D_BIRTHDAY ') ||v_count
,v_count
,trim('D_SCHOOLE ') ||v_count
,trim('D_SKILL ') ||v_count
,trim('D_QQNUMBER ') ||v_count
,trim('E_ID ') ||v_count
,trim('E_NAME ') ||v_count
,trim('E_GENDER ') ||v_count
,trim('E_CARDID ') ||v_count
,trim('E_ADDRESS ') ||v_count
,trim('E_PHONENUM ') ||v_count
,trim('E_COMPANY ') ||v_count
,trim('E_LASTCOMPANY ') ||v_count
,trim('E_LEADER ') ||v_count
,trim('E_BIRTHDAY ') ||v_count
,v_count
,trim('E_SCHOOLE ') ||v_count
,trim('E_SKILL ') ||v_count
,trim('E_QQNUMBER ') ||v_count
);
v_count:= v_count+1;
end loop;
commit;
end proc_test04;

阅读全文

0 0