Set Operators
Set operators are used to combine the results of two or more SELECT queries. These operators allow you to perform set operations on the result sets, such as union, intersection, and difference. The main set operators in Oracle SQL are:
UNION:
Combines the results of two SELECT statements, removing duplicate rows.