Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-24093: AQ agent string not granted privileges of database user string

1 Answers  


LSX-00126: facet "~1S" has invalid value "~u"

1 Answers  


ORA-12028: materialized view type is not supported by master site string

1 Answers  


ORA-09712: orasrv: log archiver already connected.

1 Answers  


ORA-08208: ora_addr: cannot read from address file

1 Answers  






ORA-31112: fail to string for string port using xdb configuration

1 Answers  


ORA-25258: cannot register for notifications on an 8.0 style exception queue

1 Answers  


LPX-00207: expected "[" at the start of conditional section

1 Answers  


ORA-18004: outline already exists

1 Answers  


ORA-38461: XML Tag "string" already exists for the XMLType attribute "string"

1 Answers  


ORA-09793: szguns: length of user name is greater than buffer.

1 Answers  


LPX-00264: send failed to host ~s

1 Answers  






Categories