CREATE TABLE all_sales(
YEAR INTEGER NOT NULL ,
MONTH INTEGER NOT NULL ,
prd_type_id INTEGER CONSTRAINT all_sales_fk_product_types REFERENCES product_types(product_type_id),
emp_id INTEGER CONSTRAINT all_sales_fk_employees2 REFERENCES employees2(employee_id),
amount NUMBER(5,2),
CONSTRAINT all_sales_pk PRIMARY KEY (year,month,prd_type_id,emp_id)
);
INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 1, 10034.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 2, 15144.65
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 3, 20137.83
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 4, 25057.45
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 5, 17214.564
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 6, 15564.64
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 7, 12654.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 8, 17434.82
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 9, 19854.57
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 10, 21754.19
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 11, 13029.73
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 1, 2003, 12, 10034.84
);
INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 1, 1034.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 2, 1544.65
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 3, 2037.83
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 4, 2557.45
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 5, 1714.564
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 6, 1564.64
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 7, 1264.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 8, 1734.82
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 9, 1854.57
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 10, 2754.19
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 11, 1329.73
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 2, 2003, 12, 1034.84
);
INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 1, 6034.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 2, 1944.65
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 3, 2537.83
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 4, 4557.45
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 5, 3714.564
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 6, 3564.64
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 7, 21264.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 8, 21734.82
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 9, 12854.57
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 10, 32754.19
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 11, 15329.73
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 3, 2003, 12, 14034.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 1, 3034.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 2, 2944.65
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 3, 5537.83
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 4, 3557.45
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 5, 2714.564
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 6, 7564.64
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 7, 1264.84
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 8, 21734.82
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 9, 14854.57
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 10, 22754.19
);INSERT INTO all_sales (
emp_id, prd_type_id, year, month, amount
) VALUES (
21, 4, 2003, 11, 11329.73
);
是不是表中限制条件太多,像上面的sql insert 语句在文件里有44kb ,我试过oracle insert ,sql insert ,pl/sql inser 没有一个是大五分内导完的
且在关联上有无索引