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

IMG-00544: invalid compressionQuality specified

1 Answers  


NID-00106: LOGIN to target database failed with Oracle error: string

1 Answers  


DRG-51202: invalid key mapping operation mode : string

1 Answers  


SQL*Loader-00430: NULL nested table element is not allowed

1 Answers  


RMAN-08102: channel string: located backup piece: string

1 Answers  


ORA-02310: exceeded maximum number of allowable columns in table

1 Answers  


PROC-00013: Cannot perform cluster registry operation because one of the parameters is NULL.

1 Answers  


ORA-02476: can not create index due to parallel direct load on table

1 Answers  


QSM-00768: the search condition is invalid for the requested operation

1 Answers  


ORA-12817: parallel query option must be enabled

1 Answers  


ORA-13364: layer dimensionality does not match geometry dimensions

1 Answers  


ORA-02797: No requests available

1 Answers  


Categories