oracle:sql:union
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| oracle:sql:union [2021/08/11 10:53] – created peter | oracle:sql:union [2021/08/11 10:54] (current) – peter | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Oracle - SQL - Union ====== | ====== Oracle - SQL - Union ====== | ||
| + | |||
| + | ===== Union ===== | ||
| <code sql> | <code sql> | ||
| Line 6: | Line 8: | ||
| SELECT column_name(s) FROM table_name2 | SELECT column_name(s) FROM table_name2 | ||
| </ | </ | ||
| + | |||
| + | ---- | ||
| + | |||
| + | ===== Union All ===== | ||
| + | |||
| + | <code sql> | ||
| + | SELECT column_name(s) FROM table_name1 | ||
| + | UNION ALL | ||
| + | SELECT column_name(s) FROM table_name2 | ||
| + | </ | ||
| + | |||
oracle/sql/union.1628679226.txt.gz · Last modified: 2021/08/11 10:53 by peter