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 没有一个是大五分内导完的
解决方案 »
- connect by
- 如何过滤数据为同一个公司的最新一条货物?
- Oracle基于表创建新表
- 求一oracle存储过程
- 将dbf中的数据导入到oracle中
- oracle中的sql*plus登陆的问题
- 弱弱地问一句,怎么样的sql语句称为存储过程
- 如何在存储过程中调用另一个数据库中包?多谢!
- 高手们,救命啊(Redhat Linux 8.0 下如何安装 Oracle 8.1.7)
- 如何在大型数据表(百万条记录以上)中快速访问及操作数据库记录,如何实现?
- 使用Oracle数据库,做分页,需要对数据库做什么操作?
- (Help)如何通过PL/SQL把Oracle数据库关系表导出到Visco?(在线等)
且在关联上有无索引