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-07472: snclrd: open error when opening sgadef.dbf file.

1 Answers  


ORA-32601: value for retention cannot be provided

1 Answers  


ORA-03286: ALLOCATE EXTENT not valid for HASH CLUSTERS

1 Answers  


NNO-00306: server shutdown countdown aborted

1 Answers  


ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified

1 Answers  


LFI-00147: File string.string does not exist

1 Answers  


PCB-00106: Unable to open INCLUDE file "string"

1 Answers  


ORA-09270: szalloc: error allocating memory for security

1 Answers  


ORA-01677: standby file name convert parameters differ from other instance

1 Answers  


ORA-32131: bind data type cannot be changed

1 Answers  


ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'

1 Answers  


ORA-12534: TNS:operation not supported

1 Answers  


Categories