ORA-00913: too many values
ORA-00913: too many values
Cause:
The SQL statement requires two sets of values equal in number.
Solution:
Check the number of items in each set and change the SQL statement to make them equal.
Example:
SELECT * FROM COURSE c WHERE c.COURSE_ID IN (SELECT o.* FROM ORDERS o);
Output:
ORA-00913: too many values
Correct
SELECT * FROM COURSE c WHERE c.COURSE_ID IN (SELECT o.COURSE_ID FROM ORDERS o);