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 |
ORA-16618: response document of size "string" bytes is too large
ORA-02824: Request free list is empty
ORA-32307: must use FROM ONLY clause when referencing an object table
ORA-01874: time zone hour must be between -12 and 13
ORA-37111: Unable to load the OLAP API sharable library: (string)
NNL-00244: Processing of modification requests is now disabled
ORA-33308: (DBVALID04) SEVERE ERROR: Record number used but not allocated
NNO-00151: warning: ignoring hint for domain "string", server is authoritative
TNS-01055: Successfully stopped the listener
ORA-02214: duplicate BACKUP option specification
PLS-00607: SQLJ Object Types can have only SQLJ Types as its supertype or subtype
IMP-00043: export file character set inconsistent