Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00396: INSERT statement's subquery yields wrong number
of columns
- 1 Answers
- 3669 Views
- I also Faced
- E-Mail Answers
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 |
ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications
TNS-12606: TNS: Application timeout occurred
NNL-00223: Statistic counters are next logged in string
ORA-30130: invalid parameter key type received
RMAN-06606: RMAN configuration parameters are successfully reset to default value
ORA-00361: cannot remove last log member string for group string
ORA-22980: must specify a set of attributes for the WITH OBJECT OID clause
TNS-00559: load of Entrust certificate failed
ORA-38429: invalid datatype for a stored attribute: string
ORA-33068: (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy
ORA-29831: operator binding not found
Oracle Errors 
