Error: ORA-00913: too many values (when inserting data in Oracle SQL*Plus 8.0).

Message

ORA-00913: too many values

Cause of Error

This behavior occurs because the number of values that you are trying to insert does not match 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 four values when the underlying table can only store three values in a row (or three 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 (including any 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