分析函式的建表指令碼all_sales
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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 分析表的crontab指令碼指令碼
- 怎樣得到建表(儲存過程,函式等)的DDL指令碼,請看案例儲存過程函式指令碼
- 建庫和表的指令碼.sql指令碼SQL
- ORACLE分析表和索引的指令碼Oracle索引指令碼
- count 函式原始碼分析函式原始碼
- 8、在Shell指令碼中使用函式指令碼函式
- Vue原始碼: 建構函式入口Vue原始碼函式
- Mysql建表、索引、函式、查詢使用中的坑！！！MySql索引函式
- slab原始碼分析--kmalloc函式分析原始碼函式
- SAP Spartacus Popover Directive 建構函式的用途分析函式
- 類的建構函式和解構函式函式
- 預設建構函式、引數化建構函式、複製建構函式、解構函式函式
- 程式碼保護軟體VMP逆向分析虛擬機器指令：指令中包含了函式呼叫虛擬機函式
- C/C++—— C++中建構函式不能是虛擬函式的原因分析C++函式
- shell指令碼獲取函式返回值指令碼函式
- Oracle分析函式七——分析函式案例Oracle函式
- vue原始碼解讀-建構函式Vue原始碼函式
- webgl內建函式--指數函式Web函式
- webgl內建函式--通用函式Web函式
- 使用bind()函式的產生的函式用作建構函式this的指向函式
- 建構函式與普通函式的區別函式
- Java的建構函式Java函式
- 建構函式的作用函式
- C++中建構函式，拷貝建構函式和賦值函式的詳解C++函式賦值
- 內建函式函式
- ## 建構函式函式
- 建構函式函式
- 消除複製建構函式和“模板式複製建構函式”中的冗餘程式碼 (轉)函式
- 如何編寫冪等的Bash指令碼(函式)？ · Fatih Arslan指令碼函式
- Oracle聚合函式/分析函式Oracle函式
- python內建函式-eval()函式與exec()函式的區別Python函式
- powerdesigner生成的sql建表指令碼如何去除雙引號"SQL指令碼
- [譯] 建構函式已死，建構函式萬歲！函式
- 建構函式與解構函式函式
- JavaScript建構函式和普通函式的區別JavaScript函式
- Javascript 之中的 class/建構函式/工廠函式JavaScript函式
- Java 容器系列（七）：HashMap 原始碼分析01之建構函式、內部類JavaHashMap原始碼函式
- 分析函式函式