ORA-00947: not enough values

ORA-00947: not enough values

Oracle PL/SQL error message: ORA-00947: not enough values.

Cause:

An INSERT statement with not enough values.

Solution:

Check and change your INSERT statement to avoid the duplicate values.




Example:

INSERT INTO employees(id, name, dept_id, salary) 
VALUES ('Anne', 20, 250);

SQL Error: ORA-00947: not enough values

Correct insert:

INSERT INTO employees(id, name, dept_id, salary)
VALUES (1, ‘Anne’, 20, 250);