Set operators are used to combine the records from multiple SELECT statements. The set operator is placed between the two SELECT statements. The operator tells Oracle how the records that each of the SELECT statements retrieves must be merged, compared, or discarded until one virtual table is created. The entire virtual record from each record set is evaluated against each other; therefore, the following rules apply:
Each of the SELECT clauses must have the same number of expressions.
Each expression in the SELECT clause must have the same data type as the corresponding expression in the other SELECT clauses.
Each SELECT statement is part of one overall statement. The minor SELECT statements may have all of the SELECT clauses ...