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

DRG-11004: duplicate or conflicting value for string

1 Answers  


ORA-31111: table string cannot be hierarchically enabled

1 Answers  


ORA-09714: Two Task interface: cannot obtain puname

1 Answers  


ORA-14295: column type or size mismatch between partitioning columns and subpartitioning columns

1 Answers  


ORA-22620: buffer size too small to hold the value

1 Answers  


ORA-10621: data block does not belong to the segment

1 Answers  


ORA-10659: Segment being shrunk is not a lob

1 Answers  


TNS-01420: Presentation: string

1 Answers  


ORA-02430: cannot enable constraint (string) - no such constraint

1 Answers  


ORA-39103: Timeout before worker process string finished initialization. Worker error:

1 Answers  


ORA-38740: Usable blocks value string is not valid.

1 Answers  


ORA-01623: log string is current log for instance string (thread string) - cannot drop

1 Answers  


Categories