PLS-00396: INSERT statement's subquery yields wrong number
of columns
- 1 Answers
- 3233 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 |
IMP-00400: Warning: Object type "string"."string" already exists with a different typeid
PLS-00908: The stored format of string is not supported by this release
ORA-31194: Resource string is already deleted
ORA-27033: failed to obtain file size limit
ORA-02067: transaction or savepoint rollback required
ORA-09798: Label comparison failed.
ORA-25508: database is not mounted
SQL*Loader-03120: Resumable parameters ignored -- current session not resumable
ORA-12491: DBHIGH value does not dominate DBLOW
NID-00300: Connected to database string (DBID=number)
ORA-29397: cannot grant/revoke switch privilege for string
ORA-16740: log transport service for standby "string" incorrectly set to ALTERNATE.
Oracle Errors 
