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 |
RMAN-06042: PLUS ARCHIVELOG option is not supported with non-datafile backups
ORA-08000: maximum number of session sequence lists exceeded
QSM-00782: the specified value string is an invalid date format for parameter string
ORA-12921: database is not in force logging mode
RMAN-08004: full resync complete
ORA-06601: LU6.2 Driver: Invalid database ID string
ORA-12210: TNS:error in finding Navigator data
ORA-36210: (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.
PCC-02401: Host variable arrays of this type are currently not supported
ORA-31664: unable to construct unique job name when defaulted
ORA-24364: internal error while padding blanks
ORA-01792: maximum number of columns in a table or view is 1000