| ERROR | wrong number of values in VALUES clause of INSERT statement |
| CAUSE | The number of columns in an INSERT statement does not match the number of values in the VALUES clause. For example, the following statement is faulty because no column is specified for the value 20: INSERT INTO emp (empno, ename) VALUES (7788, SCOTT, 20); |
| ACTION | Change the number of items in the column list or the number of items in the VALUES list so that the numbers match. |