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 ? | 0 Yes | 0 No |
TNS-01112: Plug and play can either be ON or OFF
ORA-06449: The list IO or the sysvendor is not installed.
ORA-37079: (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.
ORA-03280: invalid DATAFILE filename specified
DRG-11404: no primary key value specified
TNS-00237: Failed to refuse connection
ORA-02845: Invalid value for the timing wanted flag
ORA-14272: only a partition with higher bound can be reused
ORA-09768: osnmgetmsg: could not read a message
TNS-02516: No data available
ORA-25145: allocation policy already specified
ORA-30370: set operators are not supported in this context