Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

RMAN-08021: channel string: restoring controlfile

1 Answers  


ORA-02827: Invalid file number

1 Answers  


LFI-00126: Record format can only be one of Fixed or Variable.

1 Answers  


SQL*Loader-00283: file processing string "string" ignored for INFILE *

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  






ORA-27491: repeat_interval and start_date cannot both be NULL

1 Answers  


NZE-28808: Cannot retrieve method information from the configuration file.

1 Answers  


ORA-16722: unable to set LOG_ARCHIVE_DEST_STATE_n parameters

1 Answers  


ORA-21704: cannot terminate cache or connection without flushing first

1 Answers  


ORA-23362: invalid user

1 Answers  


ORA-30089: missing or invalid <datetime field>

1 Answers  


NCR-04015: NCRR: Invalid interface name

1 Answers  






Categories