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

NNL-00566: set|show log_file_name [<filename>] [<server_list>] : set|show the log file name on one or more servers

1 Answers  


ORA-28513: internal error in heterogeneous remote agent

1 Answers  


LPX-00208: unknown DTD keyword "~s"

1 Answers  


ORA-09805: conversion of category number to string failed.

1 Answers  


ORA-00381: cannot use both new and old parameters for buffer cache size specification

1 Answers  


ORA-29960: line string, string

1 Answers  


PLS-01420: INTERSECT and MINUS set operators are not ANSI

1 Answers  


ORA-01564: rollback segment is not PUBLIC

1 Answers  


ORA-32300: cannot drop a secondary materialized view "string"."string"

1 Answers  


ORA-03279: invalid INSTANCE specified

1 Answers  


ORA-30030: suppress resumable related error message

1 Answers  


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

0 Answers   Olivetti,


Categories