-- table script
CREATE TABLE employees
(
EMPLOYEE_ID NUMBER(6) NOT NULL,
FIRST_NAME VARCHAR2(20),
LAST_NAME VARCHAR2(25) NOT NULL,
SALARY NUMBER(8,2),
HIREDATE DATE,
DEPARTMENT_ID NUMBER(4)
);
CREATE SEQUENCE emp_seq --Sequence creation
START WITH 1
INCREMENT BY 1
NOCACHE;
Question: when I tried to run this insert query, I get an error "not enough values":
INSERT INTO employees (employee_id, last_name, hiredate)
VALUES ((SELECT emp_seq.nextval, 'Smith', SYSDATE FROM dual));
Can someone explain why?
I tried running nested select statement individually, getting desired result, but when tried both queries together I’m getting that error.
You need to sign in to view this answers