Oracle SQL Tutorial 15 - Set Operators
Using Set Operators
UNION:- Rows from both queries after eliminating duplication
UNION ALL:- Rows from both queries, including all duplication
INTERSECT:- Rows that are common to both queries
MINUS:- Rows in the first query that are not present in the second query