create or replace procedure prc_pubs_data
is
begin
--PUBS_TITLEAUTHOR
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('172-32-1176', 'PS3333', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('213-46-8915', 'BU1032', 2, 40);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('213-46-8915', 'BU2075', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('238-95-7766', 'PC1035', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('267-41-2394', 'BU1111', 2, 40);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('267-41-2394', 'TC7777', 2, 30);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('274-80-9391', 'BU7832', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('409-56-7008', 'BU1032', 1, 60);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('427-17-2319', 'PC8888', 1, 50);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('472-27-2349', 'TC7777', 3, 30);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('486-29-1786', 'PC9999', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('486-29-1786', 'PS7777', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('648-92-1872', 'TC4203', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('672-71-3249', 'TC7777', 1, 40);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('712-45-1867', 'MC2222', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('722-51-5454', 'MC3021', 1, 75);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('724-80-9391', 'BU1111', 1, 60);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('724-80-9391', 'PS1372', 2, 25);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('756-30-7391', 'PS1372', 1, 75);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('807-91-6654', 'TC3218', 1, 100);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('846-92-7186', 'PC8888', 2, 50);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('899-46-2035', 'MC3021', 2, 25);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('899-46-2035', 'PS2091', 2, 50);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('998-72-3567', 'PS2091', 1, 50);
insert into PUBS_TITLEAUTHOR (AU_ID, TITLE_ID, AU_ORD, ROYALTYPER)
values ('998-72-3567', 'PS2106', 1, 100);
commit;
dbms_output.put_line('数据已全部插入PUBS_TITLEAUTHOR表!');
--PUBS_SALES
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('6380', '6871', to_date('14-09-1994', 'dd-mm-yyyy'), 5, 'Net 60', 'BU1032');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('6380', '722a', to_date('13-09-1994', 'dd-mm-yyyy'), 3, 'Net 60', 'PS2091');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7066', 'A2976', to_date('24-05-1993', 'dd-mm-yyyy'), 50, 'Net 30', 'PC8888');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7066', 'QA7442.3', to_date('13-09-1994', 'dd-mm-yyyy'), 75, 'ON invoice', 'PS2091');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7067', 'D4482', to_date('14-09-1994', 'dd-mm-yyyy'), 10, 'Net 60', 'PS2091');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7067', 'P2121', to_date('15-06-1992', 'dd-mm-yyyy'), 40, 'Net 30', 'TC3218');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7067', 'P2121', to_date('15-06-1992', 'dd-mm-yyyy'), 20, 'Net 30', 'TC4203');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7067', 'P2121', to_date('15-06-1992', 'dd-mm-yyyy'), 20, 'Net 30', 'TC7777');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7131', 'N914008', to_date('14-09-1994', 'dd-mm-yyyy'), 20, 'Net 30', 'PS2091');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7131', 'N914014', to_date('14-09-1994', 'dd-mm-yyyy'), 25, 'Net 30', 'MC3021');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7131', 'P3087a', to_date('29-05-1993', 'dd-mm-yyyy'), 20, 'Net 60', 'PS1372');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7131', 'P3087a', to_date('29-05-1993', 'dd-mm-yyyy'), 25, 'Net 60', 'PS2106');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7131', 'P3087a', to_date('29-05-1993', 'dd-mm-yyyy'), 15, 'Net 60', 'PS3333');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7131', 'P3087a', to_date('29-05-1993', 'dd-mm-yyyy'), 25, 'Net 60', 'PS7777');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7896', 'QQ2299', to_date('28-10-1993', 'dd-mm-yyyy'), 15, 'Net 60', 'BU7832');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7896', 'TQ456', to_date('12-12-1993', 'dd-mm-yyyy'), 10, 'Net 60', 'MC2222');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('7896', 'X999', to_date('21-02-1993', 'dd-mm-yyyy'), 35, 'ON invoice', 'BU2075');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('8042', '423LL922', to_date('14-09-1994', 'dd-mm-yyyy'), 15, 'ON invoice', 'MC3021');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('8042', '423LL930', to_date('14-09-1994', 'dd-mm-yyyy'), 10, 'ON invoice', 'BU1032');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('8042', 'P723', to_date('11-03-1993', 'dd-mm-yyyy'), 25, 'Net 30', 'BU1111');
insert into PUBS_SALES (STOR_ID, ORD_NUM, ORD_DATE, QTY, PAYTERMS, TITLE_ID)
values ('8042', 'QA879.1', to_date('22-05-1993', 'dd-mm-yyyy'), 30, 'Net 30', 'PC1035');
commit;
dbms_output.put_line('数据已全部插入PUBS_SALES表!');
--PUBS_ROYSCHED
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('BU1032', 0, 5000, 10);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('BU1032', 5001, 50000, 12);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('PC1035', 0, 2000, 10);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('PC1035', 2001, 3000, 12);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('PC1035', 3001, 4000, 14);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('PC1035', 4001, 10000, 16);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('PC1035', 10001, 50000, 18);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('BU2075', 0, 1000, 10);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('BU2075', 1001, 3000, 12);
insert into PUBS_ROYSCHED (TITLE_ID, LORANGE, HIRANGE, ROYALTY)
values ('BU2075', 3001, 5000, 1
Oracle下的pubs数据库
需积分: 3 170 浏览量
2008-01-14
15:47:05
上传
评论
收藏 280KB ZIP 举报
pubs.zip （8个子文件） 
pubs 
单词列表(s2 sql).xls 31KB pubs 单词列表.xls 30KB
prc_pubs_data.sql 41KB prc_pubs_tab.sql 8KB northwind 单词列表.xls 56KB 执行存储过程.sql 2KB 单词列表(s1 sql).xls 355KB prc_pubs_contraints.sql 8KB资源评论
