ORA-00947: not enough values - Oracle Database 12c Error Messages

Channel:

java frm

Subscribers:

5,740

Published on March 11, 2023 9:54:22 AM ● Video Link: https://www.youtube.com/watch?v=X-Jeg5YgMzQ

Duration: 1:44

0 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

ORA-00947: not enough values.
Cause: This error occurs when a SQL statement requires two sets of values equal in number,
but the second set contains fewer items than the first set. This can occur in a WHERE or HAVING clause in which a nested SELECT returns too few columns as in:

WHERE (A,B) IN (SELECT C FROM ...)

Another common cause of this error is an INSERT statement in which the VALUES or SELECT clause does not contain enough values needed for the INSERT, as in

INSERT INTO EMP(EMPNO,ENAME) VALUES('JONES')
Action: Check the number of items in each set and change the SQL statement to make them equal.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database