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 ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00212: Cache checkpointing is now disabled

1 Answers  


KUP-04077: unknown format specifier in file name string

1 Answers  


ORA-14265: data type or length of a table subpartitioning column may not be changed

1 Answers  


NNL-00809: Queries received, multiple types: number

1 Answers  


UDE-00050: Unable to setup parameter processing.

1 Answers  






ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type

1 Answers  


ORA-16094: database shutdown during archival operation

1 Answers  


ORA-02794: Client unable to get key for shared memory

1 Answers  


ORA-27372: length of action and arguments exceeds platform limit string

1 Answers  


ORA-14457: disallowed Nested Table column in a Temporary table

1 Answers  


SQL*Loader-00513: Unable to close file (string)

1 Answers  


ORA-30475: feature not enabled: string

1 Answers  


Categories