What you’ll learn in this Chapter
✓ What are SET operators
✓ Kinds of SET operators in Oracle
✓ Joins vs SET operators
✓ Limitations of SET operators
Overview
Set operators combine the results of two component queries into a single result.
SET operators are used to join the result set of two or more queries. Each query in a SET operation, is called as component query.
Oracle also provides Joins, which are used are used to retrieve data from multiple tables. But Joins combine columns from multiple tables, whereas SET operators combine result set from component queries.
Learn how to use SET operators in Oracle through our documentation.