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-01263: Name given for file destination directory is invalid

2 Answers  


CLSR-00522: Resource string is not registered

1 Answers  


ORA-32133: Cannot get stream from LOB/FILE

1 Answers  


ORA-39956: duplicate setting for PL/SQL compiler parameter string

1 Answers  


ORA-22911: duplicate storage specification for the nested table item

1 Answers  


DRG-11720: too many synonyms per synonym ring

1 Answers  


ORA-06519: active autonomous transaction detected and rolled back

1 Answers  


ORA-31526: could not find source table string.string for CDC change table string.string

1 Answers  


NID-00337: The following datafiles are read-only:

1 Answers  


ORA-29840: indextype and implementation type are not in same schema

1 Answers  


ORA-32631: illegal use of objects in MODEL

1 Answers  


ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable

1 Answers  


Categories