Oracle Error PLS-00396: INSERT statement’s subquery yields wrong number of columns

Oracle Error Message

PLS-00396: INSERT statement’s subquery yields wrong number of columns

Reason for the Error

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 …

Solution

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.