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 |
PLS-00555: default expressions are not allowed for SQL operators
ORA-32803: value for string cannot be altered
TNS-00024: INTCTL: Unable to contact Navigator to obtain Connection Manager address
PLS-00219: label 'string' reference is out of scope
ORA-30563: outer join operator (+) not allowed in select-list
QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing
ORA-01059: parse expected before a bind or execute
TNS-02404: Service string contains no local handlers
NNO-00122: invalid name, data ignored: entry: string
QSM-00777: the specified directive string is unsupported at this time
PLS-00732: Illegal overload of ellipsis in formal parameter list
ORA-12619: TNS:unable to grant requested service