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

RMAN-06042: PLUS ARCHIVELOG option is not supported with non-datafile backups

1 Answers  


ORA-08000: maximum number of session sequence lists exceeded

1 Answers  


QSM-00782: the specified value string is an invalid date format for parameter string

1 Answers  


ORA-12921: database is not in force logging mode

1 Answers  


RMAN-08004: full resync complete

1 Answers  


ORA-06601: LU6.2 Driver: Invalid database ID string

1 Answers  


ORA-12210: TNS:error in finding Navigator data

1 Answers  


ORA-36210: (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.

1 Answers  


PCC-02401: Host variable arrays of this type are currently not supported

1 Answers  


ORA-31664: unable to construct unique job name when defaulted

1 Answers  


ORA-24364: internal error while padding blanks

1 Answers  


ORA-01792: maximum number of columns in a table or view is 1000

1 Answers  


Categories