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-10634: Segment is already being shrunk

2 Answers  


IMP-00095: Resumable parameters ignored -- current session not resumable

1 Answers  


LPX-00307: namespace prefix ~S used but not declared

1 Answers  


ORA-12043: invalid CREATE MATERIALIZED VIEW option

1 Answers  


ORA-29311: export dump file was not generated by this database, string does not match

1 Answers  


ORA-13118: invalid node_id [string]

1 Answers  


ORA-19207: scalar parameter string of XMLELEMENT cannot have an alias.

1 Answers  


NZE-28836: Wallet is not open.

1 Answers  


O2I-00114: Invalid HFILE file name

1 Answers  


KUP-01006: error signalled during parse of access parameters

1 Answers  


ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD

1 Answers  


ORA-14515: only one aubpartition name can be specified

1 Answers  


Categories