The Oracle UNION ALL operator is allow you to combine the result-set of two or more SELECT statements together. It combines the both SELECT statement and does not remove duplicate rows between the various SELECT statements.
To combines the both SELECT statement and does not remove duplicate rows between the various SELECT statements, use the following syntax:
Parameters:
tablename: The table name from which you want to perform UNION operator.
UNION ALL: To combine the result-set of two or more SELECT statements.
Note:
In the above example, the UNION ALL operator will return all records from "tblCustomer" and "tblCustomerLoan" table including duplicate rows.