Oracle 10g INSERT查询 [英] Oracle 10g INSERT query
问题描述
下面的INSERT查询给出了一个错误。错误是:无法将NULL插入empid
下面的插入语句有什么问题。谢谢。
--- INSERT EMPID比最大的现有雇主大5倍
INSERT IN SALESPERSONS (empid)
SELECT MAX(EMPID)* 5
来自销售人员
- ENAME是我的名字
INSERT INTO SALESPERSONS(ename)VALUES(我的名字);
- 排名将无论哪个等级与收入最低的 - 销售人员相关联(使用SELECT)
INSERT INTO SALESPERSONS(等级)
SELECT MIN(RANK)from SALESPERSONS
- 薪水比最低薪的销售员多10%(使用 - SELECT子句)。
INSERT INTO SALESPERSONS(薪水)
SELECT MIN(SALARY)* 0.10 + MIN(SALARY)来自SALESPERSONS
INSERT query below gives me an error. The error is: cannot insert NULL into empid
Is there anything wrong with my insert statements below. Thank you.
--- INSERT EMPID 5 TIMES GREATER THAN THE LARGEST EXISTING EMPID
INSERT INTO SALESPERSONS (empid)
SELECT MAX(EMPID) * 5
FROM SALESPERSONS
--ENAME IS MY NAME
INSERT INTO SALESPERSONS (ename) VALUES (MY NAME);
--rank will be whichever rank is associated with the lowest-paid --salesperson (using SELECT)
INSERT INTO SALESPERSONS (rank)
SELECT MIN(RANK) FROM SALESPERSONS
--salary is to be 10% more than the lowest-paid salesperson (use--SELECT clause).
INSERT INTO SALESPERSONS (salary)
SELECT MIN(SALARY)* 0.10 + MIN(SALARY) FROM SALESPERSONS
推荐答案
是:您必须在一个INSERT
查询而不是四个中执行此操作,或将最后3个插入查询更改为UPDATE
查询。
Yes: you must do that in one singleINSERT
query instead of four, or change the last 3 insert queries intoUPDATE
queries.
这篇关于Oracle 10g INSERT查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!