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-13048: recursive SQL fetch error

1 Answers  


ORA-29316: datafile string been imported twice

1 Answers  


LCD-00209: missing value for keyword at end of string [string]

1 Answers  


NNL-00569: domain_hint <domain_name> <NS_name> <NS_Addr> : Provide hint of a nameserver for a given domain

1 Answers  


DRG-12439: highlight table read failed

1 Answers  






RMAN-06703: could not open file: "string" (reason=string)

1 Answers  


NNO-00261: cannot construct configuration checkpoint file name

1 Answers  


ORA-01092: ORACLE instance terminated. Disconnection forced

1 Answers  


TNS-01191: Failed to initialize the local OS authentication subsystem

1 Answers  


SQL*Loader-00527: OCI return status: no data

1 Answers  


ORA-19584: file string already in use

1 Answers  


ORA-24031: invalid value, string should be non-NULL

1 Answers  


Categories