Error: ORA-00947: not enough values(when inserting data in Oracle SQL*Plus 8.0).

Message

ORA-00947: not enough values

Cause of Error

This behavior occurs when the number of values you are trying to insert does not match either the number of columns that you specify in the SQL INSERT statement or the number of columns that exist in the underlying table. For example, you will receive this error message when you try to insert five values when the underlying table is designed to hold six values in a row (or six columns of data).

Solution Summary

Match the list of values with the list of columns in the SQL INSERT statement or in the underlying table.

Solution Details

1) Match the list of values with the list of columns by doing one of the following:
a) If you specified the columns where the values are to be inserted in the SQL INSERT statement, match the list of values (or expressions) after the VALUES keyword with the list of columns specified before the keyword. Make sure the number of values is the same as the number of columns.
b) If you did not specify the columns in the SQL statement:
1] At the SQL*Plus prompt, type the following command, and then press ENTER to list all the columns in the underlying table:
DESCRIBE .
where is the user name of the table owner and

is the name of the table you are trying to insert data into.
2] Make sure the number of the columns in the table and the number of values to be inserted are the same.
2) Execute the revised SQL statement.

Applies to Software Version

Oracle8