分析函数的建表脚本all_sales

最新推荐文章于 2021-11-04 09:45:05 发布
最新推荐文章于 2021-11-04 09:45:05 发布
阅读量261 收藏
点赞数
学习分析函数时所用的建表脚本,初始数据我是手工输进去的[@more@]

prompt PL/SQL Developer import file
prompt Created on 2007年4月23日 by new
set feedback off
set define off
prompt Creating ALL_SALES...
create table ALL_SALES
(
YEAR NUMBER(38) not null,
MONTH NUMBER(2) not null,
PRD_TYPE_ID NUMBER not null,
EMP_ID NUMBER not null,
AMOUNT NUMBER(8,2)
)
;

prompt Loading ALL_SALES...
insert into ALL_SALES
values (2003, 1, 2, 21, 10034.84);
insert into ALL_SALES
values (2003, 2, 2, 21, 15144);
insert into ALL_SALES
values (2003, 3, 2, 21, 20137);
insert into ALL_SALES
values (2003, 4, 2, 21, 25057.45);
insert into ALL_SALES
values (2003, 5, 2, 21, 17214.56);
insert into ALL_SALES
values (2003, 6, 2, 21, 15564);
insert into ALL_SALES
values (2003, 7, 2, 21, 12654.84);
insert into ALL_SALES
values (2003, 8, 2, 21, 17434.82);
insert into ALL_SALES
values (2003, 9, 2, 21, 19854.57);
insert into ALL_SALES
values (2003, 10, 2, 21, 21669.76);
insert into ALL_SALES
values (2006, 1, 2, 21, 16034.84);
insert into ALL_SALES
values (2006, 2, 2, 21, 15644.65);
insert into ALL_SALES
values (2006, 3, 3, 21, 20167.83);
insert into ALL_SALES
values (2006, 4, 3, 21, 25056.45);
insert into ALL_SALES
values (2006, 5, 3, 21, null);
insert into ALL_SALES
values (2006, 6, 2, 21, 15564.66);
insert into ALL_SALES
values (2006, 7, 2, 21, 15644.65);
insert into ALL_SALES
values (2006, 8, 2, 21, 16434.82);
insert into ALL_SALES
values (2006, 9, 2, 21, 19654.57);
insert into ALL_SALES
values (2006, 10, 2, 21, 21764.19);
insert into ALL_SALES
values (2006, 11, 2, 21, 13026.73);
insert into ALL_SALES
values (2006, 12, 3, 21, 10034);
insert into ALL_SALES
values (2005, 1, 3, 22, 16634.84);
insert into ALL_SALES
values (2005, 1, 3, 21, 26034.84);
insert into ALL_SALES
values (2005, 2, 2, 21, 12644.65);
insert into ALL_SALES
values (2005, 3, 2, 21, null);
insert into ALL_SALES
values (2005, 4, 2, 21, 25026.45);
insert into ALL_SALES
values (2005, 5, 2, 21, 17212.66);
insert into ALL_SALES
values (2005, 6, 2, 21, 15564.26);
insert into ALL_SALES
values (2005, 7, 3, 21, 62654.82);
insert into ALL_SALES
values (2005, 8, 3, 21, 26434);
insert into ALL_SALES
values (2005, 9, 3, 21, null);
insert into ALL_SALES
values (2005, 10, 3, 21, null);
insert into ALL_SALES
values (2005, 11, 2, 21, null);
insert into ALL_SALES
values (2005, 12, 2, 21, null);
insert into ALL_SALES
values (2003, 1, 4, 21, 10034);
insert into ALL_SALES
values (2003, 2, 4, 21, 15144);
insert into ALL_SALES
values (2003, 3, 4, 21, 20137);
insert into ALL_SALES
values (2003, 4, 4, 21, 25057);
insert into ALL_SALES
values (2003, 5, 4, 21, 17214);
insert into ALL_SALES
values (2003, 6, 4, 21, 15564);
insert into ALL_SALES
values (2003, 7, 4, 21, 12654);
insert into ALL_SALES
values (2003, 8, 4, 21, 17434);
insert into ALL_SALES
values (2003, 9, 4, 21, 19854);
insert into ALL_SALES
values (2003, 10, 4, 21, 21669);
insert into ALL_SALES
values (2006, 1, 4, 21, 16034.84);
insert into ALL_SALES
values (2006, 2, 4, 21, 15644.65);
insert into ALL_SALES
values (2006, 3, 5, 21, null);
insert into ALL_SALES
values (2006, 4, 5, 21, null);
insert into ALL_SALES
values (2006, 5, 5, 21, null);
insert into ALL_SALES
values (2006, 6, 4, 21, 15564.66);
insert into ALL_SALES
values (2006, 7, 4, 21, 15644.65);
insert into ALL_SALES
values (2006, 8, 4, 21, 16434.82);
insert into ALL_SALES
values (2006, 9, 4, 21, 19654.57);
insert into ALL_SALES
values (2006, 10, 4, 21, 21764.19);
insert into ALL_SALES
values (2006, 11, 4, 21, 13026.73);
insert into ALL_SALES
values (2006, 12, 5, 21, null);
insert into ALL_SALES
values (2005, 1, 5, 22, null);
insert into ALL_SALES
values (2005, 1, 5, 21, null);
insert into ALL_SALES
values (2005, 2, 4, 21, 12644.65);
insert into ALL_SALES
values (2005, 3, 4, 21, null);
insert into ALL_SALES
values (2005, 4, 4, 21, 25026.45);
insert into ALL_SALES
values (2005, 5, 4, 21, 17212.66);
insert into ALL_SALES
values (2005, 6, 4, 21, 15564.26);
insert into ALL_SALES
values (2005, 7, 5, 21, null);
insert into ALL_SALES
values (2005, 8, 5, 21, null);
insert into ALL_SALES
values (2005, 9, 5, 21, null);
insert into ALL_SALES
values (2005, 10, 5, 21, null);
insert into ALL_SALES
values (2005, 11, 4, 21, null);
insert into ALL_SALES
values (2005, 12, 4, 21, null);
insert into ALL_SALES
values (2003, 1, 3, 21, 10034.09);
insert into ALL_SALES
values (2003, 2, 3, 21, 15144.09);
insert into ALL_SALES
values (2003, 3, 3, 21, 20137.09);
insert into ALL_SALES
values (2003, 4, 3, 21, 25057.09);
insert into ALL_SALES
values (2003, 5, 3, 21, 17214.09);
insert into ALL_SALES
values (2003, 6, 3, 21, 15564.09);
insert into ALL_SALES
values (2003, 7, 3, 21, 12654.09);
insert into ALL_SALES
values (2003, 8, 3, 21, 17434.09);
insert into ALL_SALES
values (2003, 9, 3, 21, 19854.09);
insert into ALL_SALES
values (2003, 10, 3, 21, 21669.09);
insert into ALL_SALES
values (2006, 1, 3, 21, 16034.84);
insert into ALL_SALES
values (2006, 2, 3, 21, 15644.65);
insert into ALL_SALES
values (2006, 3, 4, 21, 20167.83);
insert into ALL_SALES
values (2006, 4, 4, 21, 25056.45);
insert into ALL_SALES
values (2006, 5, 4, 21, null);
insert into ALL_SALES
values (2006, 6, 3, 21, 15564.66);
insert into ALL_SALES
values (2006, 7, 3, 21, 15644.65);
insert into ALL_SALES
values (2006, 8, 3, 21, 16434.82);
insert into ALL_SALES
values (2006, 9, 3, 21, 19654.57);
insert into ALL_SALES
values (2006, 10, 3, 21, 21764.19);
insert into ALL_SALES
values (2006, 11, 3, 21, 13026.73);
insert into ALL_SALES
values (2006, 12, 4, 21, 10034.64);
insert into ALL_SALES
values (2005, 1, 4, 22, 16634.84);
insert into ALL_SALES
values (2005, 1, 4, 21, 26034.84);
insert into ALL_SALES
values (2005, 2, 3, 21, 12644.65);
insert into ALL_SALES
values (2005, 3, 3, 21, null);
insert into ALL_SALES
values (2005, 4, 3, 21, 25026.45);
insert into ALL_SALES
values (2005, 5, 3, 21, 17212.66);
insert into ALL_SALES
values (2005, 6, 3, 21, 15564.26);
commit;
prompt 100 records committed...
insert into ALL_SALES
values (2005, 7, 4, 21, 62654.82);
insert into ALL_SALES
values (2005, 8, 4, 21, 26434.82);
insert into ALL_SALES
values (2005, 9, 4, 21, null);
insert into ALL_SALES
values (2005, 10, 4, 21, null);
insert into ALL_SALES
values (2005, 11, 3, 21, null);
insert into ALL_SALES
values (2005, 12, 3, 21, null);
insert into ALL_SALES
values (2003, 1, 5, 21, null);
insert into ALL_SALES
values (2003, 2, 5, 21, null);
insert into ALL_SALES
values (2003, 3, 5, 21, null);
insert into ALL_SALES
values (2003, 4, 5, 21, null);
insert into ALL_SALES
values (2003, 5, 5, 21, null);
insert into ALL_SALES
values (2003, 6, 5, 21, null);
insert into ALL_SALES
values (2003, 7, 5, 21, null);
insert into ALL_SALES
values (2003, 8, 5, 21, null);
insert into ALL_SALES
values (2003, 9, 5, 21, null);
insert into ALL_SALES
values (2003, 10, 5, 21, null);
insert into ALL_SALES
values (2006, 1, 5, 21, null);
insert into ALL_SALES
values (2006, 2, 5, 21, null);
insert into ALL_SALES
values (2006, 3, 6, 21, 20167.83);
insert into ALL_SALES
values (2006, 4, 6, 21, 25056.45);
insert into ALL_SALES
values (2006, 5, 6, 21, null);
insert into ALL_SALES
values (2006, 6, 5, 21, null);
insert into ALL_SALES
values (2006, 7, 5, 21, null);
insert into ALL_SALES
values (2006, 8, 5, 21, null);
insert into ALL_SALES
values (2006, 9, 5, 21, null);
insert into ALL_SALES
values (2006, 10, 5, 21, null);
insert into ALL_SALES
values (2006, 11, 5, 21, null);
insert into ALL_SALES
values (2006, 12, 6, 21, 10034.64);
insert into ALL_SALES
values (2005, 1, 6, 22, 16634.84);
insert into ALL_SALES
values (2005, 1, 6, 21, 26034.84);
insert into ALL_SALES
values (2005, 2, 5, 21, null);
insert into ALL_SALES
values (2005, 3, 5, 21, null);
insert into ALL_SALES
values (2005, 4, 5, 21, null);
insert into ALL_SALES
values (2005, 5, 5, 21, null);
insert into ALL_SALES
values (2005, 6, 5, 21, null);
insert into ALL_SALES
values (2005, 7, 6, 21, 62654.82);
insert into ALL_SALES
values (2005, 8, 6, 21, 26434.82);
insert into ALL_SALES
values (2005, 9, 6, 21, null);
insert into ALL_SALES
values (2005, 10, 6, 21, null);
insert into ALL_SALES
values (2005, 11, 5, 21, null);
insert into ALL_SALES
values (2005, 12, 5, 21, null);
insert into ALL_SALES
values (2003, 1, 7, 21, 10034.08);
insert into ALL_SALES
values (2003, 2, 7, 21, 15144.08);
insert into ALL_SALES
values (2003, 3, 7, 21, 20137.08);
insert into ALL_SALES
values (2003, 4, 7, 21, 25057.08);
insert into ALL_SALES
values (2003, 5, 7, 21, 17214.08);
insert into ALL_SALES
values (2003, 6, 7, 21, 15564.08);
insert into ALL_SALES
values (2003, 7, 7, 21, 12654.08);
insert into ALL_SALES
values (2003, 8, 7, 21, 17434.08);
insert into ALL_SALES
values (2003, 9, 7, 21, 19854.08);
insert into ALL_SALES
values (2003, 10, 7, 21, 21669.08);
insert into ALL_SALES
values (2006, 1, 7, 21, 16034.84);
insert into ALL_SALES
values (2006, 2, 7, 21, 15644.65);
insert into ALL_SALES
values (2006, 3, 8, 21, 20167.83);
insert into ALL_SALES
values (2006, 4, 8, 21, 25056.45);
insert into ALL_SALES
values (2006, 5, 8, 21, null);
insert into ALL_SALES
values (2006, 6, 7, 21, 15564.66);
insert into ALL_SALES
values (2006, 7, 7, 21, 15644.65);
insert into ALL_SALES
values (2006, 8, 7, 21, 16434.82);
insert into ALL_SALES
values (2006, 9, 7, 21, 19654.57);
insert into ALL_SALES
values (2006, 10, 7, 21, 21764.19);
insert into ALL_SALES
values (2006, 11, 7, 21, 13026.73);
insert into ALL_SALES
values (2006, 12, 8, 21, 10034.64);
insert into ALL_SALES
values (2005, 1, 8, 22, 16634.84);
insert into ALL_SALES
values (2005, 1, 8, 21, 26034.84);
insert into ALL_SALES
values (2005, 2, 7, 21, 12644.65);
insert into ALL_SALES
values (2005, 3, 7, 21, null);
insert into ALL_SALES
values (2005, 4, 7, 21, 25026.45);
insert into ALL_SALES
values (2005, 5, 7, 21, 17212.66);
insert into ALL_SALES
values (2005, 6, 7, 21, 15564.26);
insert into ALL_SALES
values (2005, 7, 8, 21, 62654.82);
insert into ALL_SALES
values (2005, 8, 8, 21, 26434.82);
insert into ALL_SALES
values (2005, 9, 8, 21, null);
insert into ALL_SALES
values (2005, 10, 8, 21, null);
insert into ALL_SALES
values (2005, 11, 7, 21, null);
insert into ALL_SALES
values (2005, 12, 7, 21, null);
insert into ALL_SALES
values (2003, 1, 6, 21, 10034.07);
insert into ALL_SALES
values (2003, 2, 6, 21, 15144.07);
insert into ALL_SALES
values (2003, 3, 6, 21, 20137.07);
insert into ALL_SALES
values (2003, 4, 6, 21, 25057.07);
insert into ALL_SALES
values (2003, 5, 6, 21, 17214.07);
insert into ALL_SALES
values (2003, 6, 6, 21, 15564.07);
insert into ALL_SALES
values (2003, 7, 6, 21, 12654.07);
insert into ALL_SALES
values (2003, 8, 6, 21, 17434.07);
insert into ALL_SALES
values (2003, 9, 6, 21, 19854.07);
insert into ALL_SALES
values (2003, 10, 6, 21, 21669.07);
insert into ALL_SALES
values (2006, 1, 6, 21, 16034.84);
insert into ALL_SALES
values (2006, 2, 6, 21, 15644.65);
insert into ALL_SALES
values (2006, 3, 7, 21, 20167.83);
insert into ALL_SALES
values (2006, 4, 7, 21, 25056.45);
insert into ALL_SALES
values (2006, 5, 7, 21, null);
insert into ALL_SALES
values (2006, 6, 6, 21, 15564.66);
insert into ALL_SALES
values (2006, 7, 6, 21, 15644.65);
insert into ALL_SALES
values (2006, 8, 6, 21, 16434.82);
insert into ALL_SALES
values (2006, 9, 6, 21, 19654.57);
insert into ALL_SALES
values (2006, 10, 6, 21, 21764.19);
insert into ALL_SALES
values (2006, 11, 6, 21, 13026.73);
insert into ALL_SALES
values (2006, 12, 7, 21, 10034.64);
insert into ALL_SALES
values (2005, 1, 7, 22, 16634.84);
insert into ALL_SALES
values (2005, 1, 7, 21, 26034.84);
commit;
prompt 200 records committed...
insert into ALL_SALES
values (2005, 2, 6, 21, 12644.65);
insert into ALL_SALES
values (2005, 3, 6, 21, null);
insert into ALL_SALES
values (2005, 4, 6, 21, 25026.45);
insert into ALL_SALES
values (2005, 5, 6, 21, 17212.66);
insert into ALL_SALES
values (2005, 6, 6, 21, 15564.26);
insert into ALL_SALES
values (2005, 7, 7, 21, 62654.82);
insert into ALL_SALES
values (2005, 8, 7, 21, 26434.82);
insert into ALL_SALES
values (2005, 9, 7, 21, null);
insert into ALL_SALES
values (2005, 10, 7, 21, null);
insert into ALL_SALES
values (2005, 11, 6, 21, null);
insert into ALL_SALES
values (2005, 12, 6, 21, null);
insert into ALL_SALES
values (2003, 1, 4, 21, 10034.06);
insert into ALL_SALES
values (2003, 2, 4, 21, 15144.06);
insert into ALL_SALES
values (2003, 3, 4, 21, 20137.06);
insert into ALL_SALES
values (2003, 4, 4, 21, 25057.06);
insert into ALL_SALES
values (2003, 5, 4, 21, 17214.06);
insert into ALL_SALES
values (2003, 6, 4, 21, 15564.06);
insert into ALL_SALES
values (2003, 7, 4, 21, 12654.06);
insert into ALL_SALES
values (2003, 8, 4, 21, 17434.06);
insert into ALL_SALES
values (2003, 9, 4, 21, 19854.06);
insert into ALL_SALES
values (2003, 10, 4, 21, 21669.06);
insert into ALL_SALES
values (2006, 1, 4, 21, 16034.84);
insert into ALL_SALES
values (2006, 2, 4, 21, 15644.65);
insert into ALL_SALES
values (2006, 3, 5, 21, null);
insert into ALL_SALES
values (2006, 4, 5, 21, null);
insert into ALL_SALES
values (2006, 5, 5, 21, null);
insert into ALL_SALES
values (2006, 6, 4, 21, 15564.66);
insert into ALL_SALES
values (2006, 7, 4, 21, 15644.65);
insert into ALL_SALES
values (2006, 8, 4, 21, 16434.82);
insert into ALL_SALES
values (2006, 9, 4, 21, 19654.57);
insert into ALL_SALES
values (2006, 10, 4, 21, 21764.19);
insert into ALL_SALES
values (2006, 11, 4, 21, 13026.73);
insert into ALL_SALES
values (2006, 12, 5, 21, null);
insert into ALL_SALES
values (2005, 1, 5, 22, null);
insert into ALL_SALES
values (2005, 1, 5, 21, null);
insert into ALL_SALES
values (2005, 2, 4, 21, 12644.65);
insert into ALL_SALES
values (2005, 3, 4, 21, null);
insert into ALL_SALES
values (2005, 4, 4, 21, 25026.45);
insert into ALL_SALES
values (2005, 5, 4, 21, 17212.66);
insert into ALL_SALES
values (2005, 6, 4, 21, 15564.26);
insert into ALL_SALES
values (2005, 7, 5, 21, null);
insert into ALL_SALES
values (2005, 8, 5, 21, null);
insert into ALL_SALES
values (2005, 9, 5, 21, null);
insert into ALL_SALES
values (2005, 10, 5, 21, null);
insert into ALL_SALES
values (2005, 11, 4, 21, null);
insert into ALL_SALES
values (2005, 12, 4, 21, null);
insert into ALL_SALES
values (2003, 1, 2, 22, 10034.05);
insert into ALL_SALES
values (2003, 2, 2, 22, 15144.05);
insert into ALL_SALES
values (2003, 3, 2, 22, 20137.05);
insert into ALL_SALES
values (2003, 4, 2, 22, 25057.05);
insert into ALL_SALES
values (2003, 5, 2, 22, 17214.05);
insert into ALL_SALES
values (2003, 6, 2, 22, 15564.05);
insert into ALL_SALES
values (2003, 7, 2, 22, 12654.05);
insert into ALL_SALES
values (2003, 8, 2, 22, 17434.05);
insert into ALL_SALES
values (2003, 9, 2, 22, 19854.05);
insert into ALL_SALES
values (2003, 10, 2, 22, 21669.05);
insert into ALL_SALES
values (2006, 1, 2, 22, 16034.84);
insert into ALL_SALES
values (2006, 2, 2, 22, 15644.65);
insert into ALL_SALES
values (2006, 3, 3, 22, 20167.83);
insert into ALL_SALES
values (2006, 4, 3, 22, 25056.45);
insert into ALL_SALES
values (2006, 5, 3, 22, null);
insert into ALL_SALES
values (2006, 6, 2, 22, 15564.66);
insert into ALL_SALES
values (2006, 7, 2, 22, 15644.65);
insert into ALL_SALES
values (2006, 8, 2, 22, 16434.82);
insert into ALL_SALES
values (2006, 9, 2, 22, 19654.57);
insert into ALL_SALES
values (2006, 10, 2, 22, 21764.19);
insert into ALL_SALES
values (2006, 11, 2, 22, 13026.73);
insert into ALL_SALES
values (2006, 12, 3, 22, 10034.64);
insert into ALL_SALES
values (2005, 1, 3, 23, 16634.84);
insert into ALL_SALES
values (2005, 1, 3, 22, 26034.84);
insert into ALL_SALES
values (2005, 2, 2, 22, 12644.65);
insert into ALL_SALES
values (2005, 3, 2, 22, null);
insert into ALL_SALES
values (2005, 4, 2, 22, 25026.45);
insert into ALL_SALES
values (2005, 5, 2, 22, 17212.66);
insert into ALL_SALES
values (2005, 6, 2, 22, 15564.26);
insert into ALL_SALES
values (2005, 7, 3, 22, 62654.82);
insert into ALL_SALES
values (2005, 8, 3, 22, 26434.82);
insert into ALL_SALES
values (2005, 9, 3, 22, null);
insert into ALL_SALES
values (2005, 10, 3, 22, null);
insert into ALL_SALES
values (2005, 11, 2, 22, null);
insert into ALL_SALES
values (2005, 12, 2, 22, null);
insert into ALL_SALES
values (2003, 1, 4, 22, 10034.04);
insert into ALL_SALES
values (2003, 2, 4, 22, 15144.14);
insert into ALL_SALES
values (2003, 3, 4, 22, 20137.23);
insert into ALL_SALES
values (2003, 4, 4, 22, 25057.42);
insert into ALL_SALES
values (2003, 5, 4, 22, 17214.33);
insert into ALL_SALES
values (2003, 6, 4, 22, 15564.22);
insert into ALL_SALES
values (2003, 7, 4, 22, 12654.65);
insert into ALL_SALES
values (2003, 8, 4, 22, 17434.32);
insert into ALL_SALES
values (2003, 9, 4, 22, 19854.15);
insert into ALL_SALES
values (2003, 10, 4, 22, 21669.51);
insert into ALL_SALES
values (2006, 1, 4, 22, 16034.84);
insert into ALL_SALES
values (2006, 2, 4, 22, 15644.65);
insert into ALL_SALES
values (2006, 3, 5, 22, null);
insert into ALL_SALES
values (2006, 4, 5, 22, null);
insert into ALL_SALES
values (2006, 5, 5, 22, null);
insert into ALL_SALES
values (2006, 6, 4, 22, 15564.66);
insert into ALL_SALES
values (2006, 7, 4, 22, 15644.65);
insert into ALL_SALES
values (2006, 8, 4, 22, 16434.82);
insert into ALL_SALES
values (2006, 9, 4, 22, 19654.57);
commit;
prompt 300 records committed...
insert into ALL_SALES
values (2006, 10, 4, 22, 21764.19);
insert into ALL_SALES
values (2006, 11, 4, 22, 13026.73);
insert into ALL_SALES
values (2006, 12, 5, 22, null);
insert into ALL_SALES
values (2005, 1, 5, 23, null);
insert into ALL_SALES
values (2005, 1, 5, 22, null);
insert into ALL_SALES
values (2005, 2, 4, 22, 12644.65);
insert into ALL_SALES
values (2005, 3, 4, 22, null);
insert into ALL_SALES
values (2005, 4, 4, 22, 25026.45);
insert into ALL_SALES
values (2005, 5, 4, 22, 17212.66);
insert into ALL_SALES
values (2005, 6, 4, 22, 15564.26);
insert into ALL_SALES
values (2005, 7, 5, 22, null);
insert into ALL_SALES
values (2005, 8, 5, 22, null);
insert into ALL_SALES
values (2005, 9, 5, 22, null);
insert into ALL_SALES
values (2005, 10, 5, 22, null);
insert into ALL_SALES
values (2005, 11, 4, 22, null);
insert into ALL_SALES
values (2005, 12, 4, 22, null);
insert into ALL_SALES
values (2003, 1, 3, 22, 10034.22);
insert into ALL_SALES
values (2003, 2, 3, 22, 15144.11);
insert into ALL_SALES
values (2003, 3, 3, 22, 20137.66);
insert into ALL_SALES
values (2003, 4, 3, 22, 25057.61);
insert into ALL_SALES
values (2003, 5, 3, 22, 17214.32);
insert into ALL_SALES
values (2003, 6, 3, 22, 15564.25);
insert into ALL_SALES
values (2003, 7, 3, 22, 12654.32);
insert into ALL_SALES
values (2003, 8, 3, 22, 17434.23);
insert into ALL_SALES
values (2003, 9, 3, 22, 19854.55);
insert into ALL_SALES
values (2003, 10, 3, 22, 21669.45);
insert into ALL_SALES
values (2006, 1, 3, 22, 16034.84);
insert into ALL_SALES
values (2006, 2, 3, 22, 15644.65);
insert into ALL_SALES
values (2006, 3, 4, 22, 20167.83);
insert into ALL_SALES
values (2006, 4, 4, 22, 25056.45);
insert into ALL_SALES
values (2006, 5, 4, 22, null);
insert into ALL_SALES
values (2006, 6, 3, 22, 15564.66);
insert into ALL_SALES
values (2006, 7, 3, 22, 15644.65);
insert into ALL_SALES
values (2006, 8, 3, 22, 16434.82);
insert into ALL_SALES
values (2006, 9, 3, 22, 19654.57);
insert into ALL_SALES
values (2006, 10, 3, 22, 21764.19);
insert into ALL_SALES
values (2006, 11, 3, 22, 13026.73);
insert into ALL_SALES
values (2006, 12, 4, 22, 10034.64);
insert into ALL_SALES
values (2005, 1, 4, 23, 16634.84);
insert into ALL_SALES
values (2005, 1, 4, 22, 26034.84);
insert into ALL_SALES
values (2005, 2, 3, 22, 12644.65);
insert into ALL_SALES
values (2005, 3, 3, 22, null);
insert into ALL_SALES
values (2005, 4, 3, 22, 25026.45);
insert into ALL_SALES
values (2005, 5, 3, 22, 17212.66);
insert into ALL_SALES
values (2005, 6, 3, 22, 15564.26);
insert into ALL_SALES
values (2005, 7, 4, 22, 62654.82);
insert into ALL_SALES
values (2005, 8, 4, 22, 26434.82);
insert into ALL_SALES
values (2005, 9, 4, 22, null);
insert into ALL_SALES
values (2005, 10, 4, 22, null);
insert into ALL_SALES
values (2005, 11, 3, 22, null);
insert into ALL_SALES
values (2005, 12, 3, 22, null);
insert into ALL_SALES
values (2003, 1, 5, 22, null);
insert into ALL_SALES
values (2003, 2, 5, 22, null);
insert into ALL_SALES
values (2003, 3, 5, 22, null);
insert into ALL_SALES
values (2003, 4, 5, 22, null);
insert into ALL_SALES
values (2003, 5, 5, 22, null);
insert into ALL_SALES
values (2003, 6, 5, 22, null);
insert into ALL_SALES
values (2003, 7, 5, 22, null);
insert into ALL_SALES
values (2003, 8, 5, 22, null);
insert into ALL_SALES
values (2003, 9, 5, 22, null);
insert into ALL_SALES
values (2003, 10, 5, 22, null);
insert into ALL_SALES
values (2006, 1, 5, 22, null);
insert into ALL_SALES
values (2006, 2, 5, 22, null);
insert into ALL_SALES
values (2006, 3, 6, 22, 20167.83);
insert into ALL_SALES
values (2006, 4, 6, 22, 25056.45);
insert into ALL_SALES
values (2006, 5, 6, 22, null);
insert into ALL_SALES
values (2006, 6, 5, 22, null);
insert into ALL_SALES
values (2006, 7, 5, 22, null);
insert into ALL_SALES
values (2006, 8, 5, 22, null);
insert into ALL_SALES
values (2006, 9, 5, 22, null);
insert into ALL_SALES
values (2006, 10, 5, 22, null);
insert into ALL_SALES
values (2006, 11, 5, 22, null);
insert into ALL_SALES
values (2006, 12, 6, 22, 10034.64);
insert into ALL_SALES
values (2005, 1, 6, 23, 16634.84);
insert into ALL_SALES
values (2005, 1, 6, 22, 26034.84);
insert into ALL_SALES
values (2005, 2, 5, 22, null);
insert into ALL_SALES
values (2005, 3, 5, 22, null);
insert into ALL_SALES
values (2005, 4, 5, 22, null);
insert into ALL_SALES
values (2005, 5, 5, 22, null);
insert into ALL_SALES
values (2005, 6, 5, 22, null);
insert into ALL_SALES
values (2005, 7, 6, 22, 62654.82);
insert into ALL_SALES
values (2005, 8, 6, 22, 26434.82);
insert into ALL_SALES
values (2005, 9, 6, 22, null);
insert into ALL_SALES
values (2005, 10, 6, 22, null);
insert into ALL_SALES
values (2005, 11, 5, 22, null);
insert into ALL_SALES
values (2005, 12, 5, 22, null);
insert into ALL_SALES
values (2003, 1, 7, 22, 10034.84);
insert into ALL_SALES
values (2003, 2, 7, 22, 15144.65);
insert into ALL_SALES
values (2003, 3, 7, 22, 20137.83);
insert into ALL_SALES
values (2003, 4, 7, 22, 25057.45);
insert into ALL_SALES
values (2003, 5, 7, 22, 17214.56);
insert into ALL_SALES
values (2003, 6, 7, 22, 15564.64);
insert into ALL_SALES
values (2003, 7, 7, 22, 12654.84);
insert into ALL_SALES
values (2003, 8, 7, 22, 17434.82);
insert into ALL_SALES
values (2003, 9, 7, 22, 19854.57);
insert into ALL_SALES
values (2003, 10, 7, 22, 21669.76);
insert into ALL_SALES
values (2006, 1, 7, 22, 16034.84);
insert into ALL_SALES
values (2006, 2, 7, 22, 15644.65);
insert into ALL_SALES
values (2006, 3, 8, 22, 20167.83);
insert into ALL_SALES
values (2006, 4, 8, 22, 25056.45);
commit;
prompt 400 records committed...
insert into ALL_SALES
values (2006, 5, 8, 22, null);
insert into ALL_SALES
values (2006, 6, 7, 22, 15564.66);
insert into ALL_SALES
values (2006, 7, 7, 22, 15644.65);
insert into ALL_SALES
values (2006, 8, 7, 22, 16434.82);
insert into ALL_SALES
values (2006, 9, 7, 22, 19654.57);
insert into ALL_SALES
values (2006, 10, 7, 22, 21764.19);
insert into ALL_SALES
values (2006, 11, 7, 22, 13026.73);
insert into ALL_SALES
values (2006, 12, 8, 22, 10034.64);
insert into ALL_SALES
values (2005, 1, 8, 23, 16634.84);
insert into ALL_SALES
values (2005, 1, 8, 22, 26034.84);
insert into ALL_SALES
values (2005, 2, 7, 22, 12644.65);
insert into ALL_SALES
values (2005, 3, 7, 22, null);
insert into ALL_SALES
values (2005, 4, 7, 22, 25026.45);
insert into ALL_SALES
values (2005, 5, 7, 22, 17212.66);
insert into ALL_SALES
values (2005, 6, 7, 22, 15564.26);
insert into ALL_SALES
values (2005, 7, 8, 22, 62654.82);
insert into ALL_SALES
values (2005, 8, 8, 22, 26434.82);
insert into ALL_SALES
values (2005, 9, 8, 22, null);
insert into ALL_SALES
values (2005, 10, 8, 22, null);
insert into ALL_SALES
values (2005, 11, 7, 22, null);
insert into ALL_SALES
values (2005, 12, 7, 22, null);
insert into ALL_SALES
values (2003, 1, 6, 22, 10034.84);
insert into ALL_SALES
values (2003, 2, 6, 22, 15144.65);
insert into ALL_SALES
values (2003, 3, 6, 22, 20137.83);
insert into ALL_SALES
values (2003, 4, 6, 22, 25057.45);
insert into ALL_SALES
values (2003, 5, 6, 22, 17214.56);
insert into ALL_SALES
values (2003, 6, 6, 22, 15564.64);
insert into ALL_SALES
values (2003, 7, 6, 22, 12654.84);
insert into ALL_SALES
values (2003, 8, 6, 22, 17434.82);
insert into ALL_SALES
values (2003, 9, 6, 22, 19854.57);
insert into ALL_SALES
values (2003, 10, 6, 22, 21669.76);
insert into ALL_SALES
values (2006, 1, 6, 22, 16034.84);
insert into ALL_SALES
values (2006, 2, 6, 22, 15644.65);
insert into ALL_SALES
values (2006, 3, 7, 22, 20167.83);
insert into ALL_SALES
values (2006, 4, 7, 22, 25056.45);
insert into ALL_SALES
values (2006, 5, 7, 22, null);
insert into ALL_SALES
values (2006, 6, 6, 22, 15564.66);
insert into ALL_SALES
values (2006, 7, 6, 22, 15644.65);
insert into ALL_SALES
values (2006, 8, 6, 22, 16434.82);
insert into ALL_SALES
values (2006, 9, 6, 22, 19654.57);
insert into ALL_SALES
values (2006, 10, 6, 22, 21764.19);
insert into ALL_SALES
values (2006, 11, 6, 22, 13026.73);
insert into ALL_SALES
values (2006, 12, 7, 22, 10034.64);
insert into ALL_SALES
values (2005, 1, 7, 23, 16634.84);
insert into ALL_SALES
values (2005, 1, 7, 22, 26034.84);
insert into ALL_SALES
values (2005, 2, 6, 22, 12644.65);
insert into ALL_SALES
values (2005, 3, 6, 22, null);
insert into ALL_SALES
values (2005, 4, 6, 22, 25026.45);
insert into ALL_SALES
values (2005, 5, 6, 22, 17212.66);
insert into ALL_SALES
values (2005, 6, 6, 22, 15564.26);
insert into ALL_SALES
values (2005, 7, 7, 22, 62654.82);
insert into ALL_SALES
values (2005, 8, 7, 22, 26434.82);
insert into ALL_SALES
values (2005, 9, 7, 22, null);
insert into ALL_SALES
values (2005, 10, 7, 22, null);
insert into ALL_SALES
values (2005, 11, 6, 22, null);
insert into ALL_SALES
values (2005, 12, 6, 22, null);
insert into ALL_SALES
values (2003, 1, 4, 22, 10034.84);
insert into ALL_SALES
values (2003, 2, 4, 22, 15144.65);
insert into ALL_SALES
values (2003, 3, 4, 22, 20137.83);
insert into ALL_SALES
values (2003, 4, 4, 22, 25057.45);
insert into ALL_SALES
values (2003, 5, 4, 22, 17214.56);
insert into ALL_SALES
values (2003, 6, 4, 22, 15564.64);
insert into ALL_SALES
values (2003, 7, 4, 22, 12654.84);
insert into ALL_SALES
values (2003, 8, 4, 22, 17434.82);
insert into ALL_SALES
values (2003, 9, 4, 22, 19854.57);
insert into ALL_SALES
values (2003, 10, 4, 22, 21669.76);
insert into ALL_SALES
values (2006, 1, 4, 22, 16034.84);
insert into ALL_SALES
values (2006, 2, 4, 22, 15644.65);
insert into ALL_SALES
values (2006, 3, 5, 22, null);
insert into ALL_SALES
values (2006, 4, 5, 22, null);
insert into ALL_SALES
values (2006, 5, 5, 22, null);
insert into ALL_SALES
values (2006, 6, 4, 22, 15564.66);
insert into ALL_SALES
values (2006, 7, 4, 22, 15644.65);
insert into ALL_SALES
values (2006, 8, 4, 22, 16434.82);
insert into ALL_SALES
values (2006, 9, 4, 22, 19654.57);
insert into ALL_SALES
values (2006, 10, 4, 22, 21764.19);
insert into ALL_SALES
values (2006, 11, 4, 22, 13026.73);
insert into ALL_SALES
values (2006, 12, 5, 22, null);
insert into ALL_SALES
values (2005, 1, 5, 23, null);
insert into ALL_SALES
values (2005, 1, 5, 22, null);
insert into ALL_SALES
values (2005, 2, 4, 22, 12644.65);
insert into ALL_SALES
values (2005, 3, 4, 22, null);
insert into ALL_SALES
values (2005, 4, 4, 22, 25026.45);
insert into ALL_SALES
values (2005, 5, 4, 22, 17212.66);
insert into ALL_SALES
values (2005, 6, 4, 22, 15564.26);
insert into ALL_SALES
values (2005, 7, 5, 22, null);
insert into ALL_SALES
values (2005, 8, 5, 22, null);
insert into ALL_SALES
values (2005, 9, 5, 22, null);
insert into ALL_SALES
values (2005, 10, 5, 22, null);
insert into ALL_SALES
values (2005, 11, 4, 22, null);
insert into ALL_SALES
values (2005, 12, 4, 22, null);
insert into ALL_SALES
values (2003, 1, 1, 22, 10034.84);
insert into ALL_SALES
values (2003, 2, 1, 22, 15144.65);
insert into ALL_SALES
values (2003, 3, 1, 22, 20137.83);
insert into ALL_SALES
values (2003, 4, 1, 22, 25057.45);
insert into ALL_SALES
values (2003, 5, 1, 22, 17214.56);
insert into ALL_SALES
values (2003, 6, 1, 22, 15564.64);
insert into ALL_SALES
values (2003, 7, 1, 22, 12654.84);
insert into ALL_SALES
values (2003, 8, 1, 22, 17434.82);
insert into ALL_SALES
values (2003, 9, 1, 22, 19854.57);
commit;
prompt 500 records committed...
insert into ALL_SALES
values (2003, 10, 1, 22, 21669.76);
insert into ALL_SALES
values (2006, 1, 1, 22, 16034.84);
insert into ALL_SALES
values (2006, 2, 1, 22, 15644.65);
insert into ALL_SALES
values (2006, 3, 2, 22, 20167.83);
insert into ALL_SALES
values (2006, 4, 2, 22, 25056.45);
insert into ALL_SALES
values (2006, 5, 2, 22, null);
insert into ALL_SALES
values (2006, 6, 1, 22, 15564.66);
insert into ALL_SALES
values (2006, 7, 1, 22, 15644.65);
insert into ALL_SALES
values (2006, 8, 1, 22, 16434.82);
insert into ALL_SALES
values (2006, 9, 1, 22, 19654.57);
insert into ALL_SALES
values (2006, 10, 1, 22, 21764.19);
insert into ALL_SALES
values (2006, 11, 1, 22, 13026.73);
insert into ALL_SALES
values (2006, 12, 2, 22, 10034.64);
insert into ALL_SALES
values (2005, 1, 2, 23, 16634.84);
insert into ALL_SALES
values (2005, 1, 2, 22, 26034.84);
insert into ALL_SALES
values (2005, 2, 1, 22, 12644.65);
insert into ALL_SALES
values (2005, 3, 1, 22, null);
insert into ALL_SALES
values (2005, 4, 1, 22, 25026.45);
insert into ALL_SALES
values (2005, 5, 1, 22, 17212.66);
insert into ALL_SALES
values (2005, 6, 1, 22, 15564.26);
insert into ALL_SALES
values (2005, 7, 2, 22, 62654.82);
insert into ALL_SALES
values (2005, 8, 2, 22, 26434.82);
insert into ALL_SALES
values (2005, 9, 2, 22, null);
insert into ALL_SALES
values (2005, 10, 2, 22, null);
insert into ALL_SALES
values (2005, 11, 1, 22, null);
insert into ALL_SALES
values (2005, 12, 1, 22, null);
insert into ALL_SALES
values (2003, 1, 1, 21, 10034.84);
insert into ALL_SALES
values (2003, 2, 1, 21, 15144.65);
insert into ALL_SALES
values (2003, 3, 1, 21, 20137.83);
insert into ALL_SALES
values (2003, 4, 1, 21, 25057.45);
insert into ALL_SALES
values (2003, 5, 1, 21, 17214.56);
insert into ALL_SALES
values (2003, 6, 1, 21, 15564.64);
insert into ALL_SALES
values (2003, 7, 1, 21, 12654.84);
insert into ALL_SALES
values (2003, 8, 1, 21, 17434.82);
insert into ALL_SALES
values (2003, 9, 1, 21, 19854.57);
insert into ALL_SALES
values (2003, 10, 1, 21, 21669.76);
insert into ALL_SALES
values (2006, 1, 1, 21, 16034.84);
insert into ALL_SALES
values (2006, 2, 1, 21, 15644.65);
insert into ALL_SALES
values (2006, 3, 2, 21, 20167.83);
insert into ALL_SALES
values (2006, 4, 2, 21, 25056.45);
insert into ALL_SALES
values (2006, 5, 2, 21, null);
insert into ALL_SALES
values (2006, 6, 1, 21, 15564.66);
insert into ALL_SALES
values (2006, 7, 1, 21, 15644.65);
insert into ALL_SALES
values (2006, 8, 1, 21, 16434.82);
insert into ALL_SALES
values (2006, 9, 1, 21, 19654.57);
insert into ALL_SALES
values (2006, 10, 1, 21, 21764.19);
insert into ALL_SALES
values (2006, 11, 1, 21, 13026.73);
insert into ALL_SALES
values (2006, 12, 2, 21, 10034.64);
insert into ALL_SALES
values (2005, 1, 2, 22, 16634.84);
insert into ALL_SALES
values (2005, 1, 2, 21, 26034.84);
insert into ALL_SALES
values (2005, 2, 1, 21, 12644.65);
insert into ALL_SALES
values (2005, 3, 1, 21, null);
insert into ALL_SALES
values (2005, 4, 1, 21, 25026.45);
insert into ALL_SALES
values (2005, 5, 1, 21, 17212.66);
insert into ALL_SALES
values (2005, 6, 1, 21, 15564.26);
insert into ALL_SALES
values (2005, 7, 2, 21, 62654.82);
insert into ALL_SALES
values (2005, 8, 2, 21, 26434.82);
insert into ALL_SALES
values (2005, 9, 2, 21, null);
insert into ALL_SALES
values (2005, 10, 2, 21, null);
insert into ALL_SALES
values (2005, 11, 1, 21, null);
insert into ALL_SALES
values (2005, 12, 1, 21, null);
commit;
prompt 560 records loaded
set feedback on
set define on
prompt Done.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/271063/viewspace-912068/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/271063/viewspace-912068/

ciyinzhi8788
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
如何处理大数据文件+录入数据
nanphonfy(南风)
09-04 4410
楼主喜欢用Java应对各种小需求，以此提高工作效率。客户在集群上提供了一份.sql文件，有2个多G，用vim等编辑器打不开，只能less一部分，而且内容有乱码（中文部分，也不清楚该份文件的编码格式）——改一下vim的字符集配置就可以解决。 下载文件到本地，尝试用notepad++打开，提示“File is to be opened by Notepate++”；用MySQL Workbench打开
去除oracle中的sql脚本中含有"records committed..."和"commit;"的行
zksfxy的博客
01-11 2103
最近实施部的同事说，最近几次在实施的时候，发现开发过程中整理的脚本有很多“records committed...”和“commit;” 严重影响了执行脚本速度。让我帮其去除脚本里面的这些提示和提交命令，遂就用JAVA的文件操作帮其做了下处理。 去除方式为： 1、首先找到发布脚本所在的文件夹，读取里面所有的文件 2、遍历文件数组，找到要进行处理的文件。 3、用指定的编码字符集对文件进行
linux 的sed 删除文本中包含某字符串的行
zhangzc12409的博客
08-10 2967
由于最近Oracle导出来的sql数据每隔300条包含了prompt xx records committed…, mysql无法识别此字符串，有几万条数据，一条条手动删除的话很麻烦。用linux 中的 sed可以解决这个问题。 用如下命令删除包含committed字符的行： sed -i '/committed/d' sql.sql 此时sql.sql就不包含prompt xx records committed…， 完美解决！ ...
省市区县代码表sql
专属路人
04-05 1031
create table T_DM_SSQX ( CODE VARCHAR2(20) not null, CAPTION VARCHAR2(100) not null, PCODE VARCHAR2(60), CHILD VARCHAR2(60), LAYER VARCHAR2(60) not null, ISOPEN CHAR(1) no...
MPC.rar_arima函数_mpc 函数_m语言脚本_协方差函数
09-21
在给定的"MPC.rar"压缩包中，可能包含的是使用MATLAB编写的M语言脚本，用于实现ARIMA模型的函数以及可能与MPC控制相关的代码。由于文件列表只给出“MPC”，具体实现细节和功能无法详细描述，需要解压并查看源代码...
quartz集群各种数据库建表脚本
08-09
"quartz集群各种数据库建表脚本" 提供了在不同类型的数据库中创建Quartz集群所需的表结构。基于quartz2.2.1版本，这个脚本应该包含了创建必要的调度表，如QRTZ_JOB_DETAILS、QRTZ_TRIGGERS、QRTZ_SIMPLE_TRIGGERS等...
json转换为SQL server建表脚本
09-17
如果JSON包含嵌套的对象，用户需要手动处理这些子层级，这可能涉及递归函数来遍历和构建复杂的SQL脚本。 6. 用户界面设计：Windows Forms应用程序需要有适当的控件来接收JSON输入（如TextBox或RichTextBox）、显示...
ipd_project_core建表脚本
03-03
ipd_project_core建表脚本
kafka-eagle（EFAK）建表脚本
最新发布
09-28
如果kafka-eagle报异常缺表，请使用该建表脚本，如果kafka-eagle报异常缺表，请使用该建表脚本，如果kafka-eagle报异常缺表，请使用该建表脚本，如果kafka-eagle报异常缺表，请使用该建表脚本，如果kafka-eagle报...
mysql prompt的用法详解
12-15
prompt命令可以在mysql提示符中显示当前用户、数据库、时间等信息 代码如下:mysql -uroot -p –prompt=”\\u@\\h:\\d \\r:\\m:\\s>”设置成功后： 代码如下:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 5Server version: 5.1.60-log Source distributionCopyright (c) 2000, 2012, Oracle and/or its affiliates. All righ
2022年节假日表ORCLE
hejl1014的博客
11-04 377
2022年节假日表ORCLE create table T_CS_WORKDAY ( rq DATE not null, lx VARCHAR2(1) ); comment on table T_CS_WORKDAY is ‘工作日参数表’; comment on column T_CS_WORKDAY.rq is ‘日期’; comment on column T_CS_WORKDAY.lx is ‘类型 0-工作日，1-假日补班，2-法定假日，3-公休日’; insert into T_CS_WORK
PLSQL Developer中控制结果集表格自动提交
bisal的专栏
07-02 695
PLSQL Developer可以说是个让人又爱又憎的工具，“爱”是他的确提供了操作Oracle数据库非常丰富、方便的功能，“憎”是他的一些隐藏配置很可能是个“坑”，就像《PLSQL D...
javascript中的prompt（）用法
leeseean的博客
03-03 6395
prompt()为弹出提示框的方法，在网页中比较常见，下面演示其用法。 点击按钮弹出对话框 点击     function myFunction(){         var x=prompt('请输入你的身高',180);          if(x!=null&&x!=''){          x='身高:'+x;          document.getElemen
Bug records
topdeveloperr的博客
12-25 194
建了一个project 目录不知道怎么回事建到一个java项目里面去了 启动的时候一直报错：objc[14867]: Class JavaLaunchHelper is implemented in both /Library/Java/JavaVirtualMachines/jdk1.8.0_60.jdk/Contents/Home/bin/java (0x10dac44c0) and /
mysql中prompt的用法_MySQL数据库之mysql prompt的用法详解
weixin_29157493的博客
01-19 1169
本文主要向大家介绍了MySQL数据库之mysql prompt的用法详解 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。prompt命令可以在mysql提示符中显示当前用户、数据库、时间等信息复制代码代码如下:mysql-uroot-p--prompt="\\u@\\h:\\d\\r:\\m:\\s>"设置成功后：复制代码代码如下:Welcometoth...
Greenplum获取建表脚本函数实现
"获取greenplumn建表语句脚本" 在Greenplum数据库中，获取建表语句通常是为了备份、迁移或者复制数据结构。这个脚本是一个PL/Python函数，名为`salesitev2.get_table_structure`，用于获取指定表的结构定义（即...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值