Oracle 10g INSERT query

See more:

Oracle

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