Oracle UNION ALL/UNION/INTERSECT/MINUS

OperatorDescriptionUNION ALLReturns all the rows retrieved by the queries, including duplicate rows.UNIONReturns all non-duplicate rows retrieved by the queries.INTERSECTReturns rows that are retrieved by both queries.MINUSReturns the remaining rows when the rows retrieved by the second query are subtracted from the rows retrieved by the first query.

Although the column names may be different, the number of columns and the column types returned by the queries must match.