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-13782: The specified user "string" does not exist.

1 Answers  


RMAN-06424: error while looking up proxy copy

1 Answers  


PCC-00029: Ambiguous option "string"

1 Answers  


NNL-00981: Timeouts, server not responding: number

1 Answers  


IMG-00516: default channel out of range

1 Answers  


ORA-14163: subpartition number string: INITRANS value must be less than MAXTRANS value

1 Answers  


ORA-28506: parse error in data dictionary translation for string stored in string

1 Answers  


ORA-02169: FREELISTS storage option not allowed

1 Answers  


ORA-39064: unable to write to the log file

1 Answers  


ORA-02151: invalid tablespace name: string

1 Answers  


PCC-02319: expression type does not match usage

1 Answers  


ORA-24907: invalid pair of callback and recepient protocol attributes

1 Answers  


Categories