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-00396: INSERT statement's subquery yields wrong number
of columns



PLS-00396: INSERT statement's subquery yields wrong number of columns..

Answer / guest

Cause: The number of columns in an INSERT statement does not
match the number of columns in a subquery select list. For
example, the following statement is faulty because no
corresponding column is specified for col3: INSERT INTO emp
(ename, empno) SELECT col1, col2, col3 FROM ...

Action: Change the number of items in the column list of the
INSERT statement or the number of items in the select list
so that the numbers match.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01261: Parameter string destination string cannot be translated

1 Answers  


PCC-00119: Value of const variable in INTO clause will be modified

1 Answers  


NZE-28761: element creation failure

1 Answers  


ORA-06022: NETASY: channel open failure

1 Answers  


TNS-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


ORA-29296: invalid encoded string

1 Answers  


ORA-07485: scg_get_inst: cannot open instance number lock.

1 Answers  


ORA-13417: null or invalid layerNumber for get functions

1 Answers  


LPX-00315: extension function ~S not supported

1 Answers  


ORA-22951: NULL returned by ORDER method

1 Answers  


PLS-00543: a PLSQL Table may not contain a nested table type or VARRAY.

1 Answers  


TNS-12690: Server Authentication failed, login cancelled

1 Answers  


Categories