PLS-00398

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

Causa: 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:

Acción: Change the select lists so that they contain the same number of items.