
ORA-00913: too many values
Cause: The SQL statement requires two sets of values equal in number. This error occurs when the second set contains more items than the first set. For example, the subquery in a WHERE or HAVING clause may return too many columns, or a VALUES or SELECT clause may return more columns than are listed in the INSERT
Action: Check the number of items in each set and change the SQL statement to make them equal
Back to previous menu
https://support.oracle.com/
http://www.oracle.com/