Oracle 19c SQL

  1. Home
  2. Docs
  3. Oracle 19c SQL
  4. 6 SET Operators

6 SET Operators

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


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.


Was this article helpful to you? Yes No

How can we help?