====== Oracle - SQL - Union ======

===== Union =====

<code sql>
SELECT column_name(s) FROM table_name1
UNION
SELECT column_name(s) FROM table_name2
</code>

----

===== Union All =====

<code sql>
SELECT column_name(s) FROM table_name1
UNION ALL
SELECT column_name(s) FROM table_name2
</code>