PLS-00398: wrong number of columns in UNION, INTERSECT, or
MINUS expression
Answer / guest
Cause: The SELECT clauses to the left and right of a UNION,
INTERSECT, or MINUS expression do not select the same number
of columns. For example, the following statement is faulty
because the select lists do not contain the same number of
items: CURSOR my_cur IS SELECT ename FROM emp INTERSECT
SELECT ename, empno FROM emp;
Action: Change the select lists so that they contain the
same number of items.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 0 No |
NID-00504: LOGFILE Output Log (NONE)
ORA-40104: invalid training data for model build
O2I-00125: Error writing to the INITFILE file
PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC
ORA-16053: DB_UNIQUE_NAME string is not in the Data Guard Configuration
ORA-00236: snapshot operation disallowed: mounted controlfile is a backup
ORA-13619: The procedure argument string is greater than the maximum allowable length of string characters.
DRG-51313: timeout while waiting for DML or optimize lock
PLS-00213: package STANDARD not accessible
ORA-09889: osnTXtt: access error on oracle executable
DRG-11718: multiple Preferred Terms for term string
ORA-31040: Property string: XML type (string) not compatible with internal memory type (string)