ORA-00913: too many values

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);