PLS-00395: wrong number of values in VALUES clause of INSERT
statement



PLS-00395: wrong number of values in VALUES clause of INSERT statement..

Answer / guest

Cause: The number of columns in an INSERT statement does not
match the number of values in the VALUES clause. For
example, the following statement is faulty because no column
is specified for the value 20: INSERT INTO emp (empno,
ename) VALUES (7788, 'SCOTT', 20);

Action: Change the number of items in the column list or the
number of items in the VALUES list so that the numbers match.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00507: Shows, sets, or cancels the time when an auto-refresh query is next issued

1 Answers  


ORA-30343: level name is not unique within this dimension

1 Answers  


LPX-00254: invalid XML declaration

1 Answers  


RMAN-06594: platform name 'string' specified in TO PLATFORM is not valid

1 Answers  


LPX-00201: unknown encoding "~s"

1 Answers  






ORA-38468: column "string" is not identified as a column storing expressions.

1 Answers  


ORA-33070: (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.

1 Answers  


LSX-00102: duplicate element "~S"

1 Answers  


LSX-00120: value is not valid restriction of parent's maxLength

1 Answers  


ORA-27415: repeat interval must start with the FREQ= clause

1 Answers  


ORA-16701: generic resource guard request failed

1 Answers  


ORA-24144: rules engine internal error, arguments: [string], [string]

1 Answers  


Categories