UNION Operator in SQL | Oracle SQL fundamentals

The UNION #operator is used to combine the result-set of two or more #SELECT statements. It removes duplicate #rows between the various #SELECT statements.
Each SELECT #statement within #UNION must have the same number of #columns.
The columns must also have similar #data types
The columns in each SELECT statement must also be in the same order.