Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-32313: REFRESH FAST of "string"."string" unsupported after PMOPs

1 Answers  


NNL-00217: Controller is sleeping for number seconds

1 Answers  


IMP-00090: Unexpected DbmsJava error number at step number while creating string

1 Answers  


TNS-00063: INTCTL: Failed to allocate memory for buffers

1 Answers  


ORA-23424: materialized view "string"."string" at string not registered

1 Answers  


ORA-38612: FI item length cannot exceed half of one database block.

1 Answers  


ORA-01937: missing or invalid role name

1 Answers  


PCC-00063: Reached end of file string before End-of-Statement at line number!

1 Answers  


ORA-09241: smsalo: error allocating SGA memory

1 Answers  


PLS-00704: 'string' must be declared as an exception

1 Answers  


ORA-06525: Length Mismatch for CHAR or RAW data

1 Answers  


TNS-02403: Bad alias string or alias not present in tnsnames.ora

1 Answers  


Categories