分析函式的建表指令碼all_sales

wmlm發表於2007-04-23
學習分析函式時所用的建表指令碼,初始資料我是手工輸進去的[@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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章