ORA-00913 too many values
What causes an ORA-00913 error?
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.
How Xynomix can help
Check the number of items in each set and change the SQL statement to make them equal.
Contact us for more information. To learn more about ways we can support your database visit our Oracle database consultancy page.
On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.