PLS-00398: wrong number of columns in UNION, INTERSECT, or
MINUS expression



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

Post New Answer

More Oracle Errors Interview Questions

TNS-01112: Plug and play can either be ON or OFF

1 Answers  


ORA-06449: The list IO or the sysvendor is not installed.

1 Answers  


ORA-37079: (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.

1 Answers  


ORA-03280: invalid DATAFILE filename specified

1 Answers  


DRG-11404: no primary key value specified

1 Answers  






TNS-00237: Failed to refuse connection

1 Answers  


ORA-02845: Invalid value for the timing wanted flag

1 Answers  


ORA-14272: only a partition with higher bound can be reused

1 Answers  


ORA-09768: osnmgetmsg: could not read a message

1 Answers  


TNS-02516: No data available

1 Answers  


ORA-25145: allocation policy already specified

1 Answers  


ORA-30370: set operators are not supported in this context

1 Answers  


Categories