Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00396: INSERT statement's subquery yields wrong number
of columns
- 1 Answers
- 3681 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 |
KUP-04029: numeric field overflowed
O2U-00202: Invalid data passed to function
ORA-01102: cannot mount database in EXCLUSIVE mode
ORA-19701: device name exceeds maximum length of string
RMAN-07506: Do you really want to catalog the above files (enter YES or NO)?
ORA-01907: TABLESPACE keyword expected
PLS-00498: illegal use of a type before its declaration
EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace
RMAN-06551: error while looking up datafilecopy for file number: string
ORA-07246: sfofi: open error, unable to open database file.
TNS-01200: The listener must be suid root
ORA-16630: That database property was deprecated.
Oracle Errors 
