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

ORA-00203: using the wrong controlfiles

1 Answers  


PLS-00313: 'string' not declared in this scope

1 Answers  


ORA-19618: cannot name files after restoreValidate has been called

1 Answers  


ORA-12670: Incorrect role password

1 Answers  


NZE-28837: no wallet descriptor

1 Answers  


ORA-28117: integrity constraint violated - parent record not found

1 Answers  


ORA-04002: INCREMENT must be a non-zero integer

1 Answers  


ORA-12815: value for INSTANCES must be greater than 0

1 Answers  


RMAN-06461: Current controlfile cannot be backed up by proxy.

1 Answers  


LPX-00279: invalid no_proxy "~s"

1 Answers  


ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.

1 Answers  


QSM-02141: the reason why the capability is disabled has escaped analysis

1 Answers  


Categories