In this lesson, you’ll learn how to use the UNION operator to combine multiple SELECT statements into one result set.
Most SQL queries contain a single
SELECT statement that returns data from one or more tables. Oracle also enables you to perform multiple queries (multiple
SELECT statements) and return the results as a single query result set. These combined queries are usually known as unions or compound queries.
There are basically two scenarios in which you would use combined queries:
To return similarly structured data from different tables in a single query
To perform multiple ...