Lesson 17. Combining Queries
In this lesson, you’ll learn how to use the UNION operator to combine multiple SELECT statements into one result set.
Understanding Combined Queries
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 ...
Get Oracle PL/SQL in 10 Minutes, Sams Teach Yourself now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
