Set Operators

Set operators combine the results of two component queries into a single result. Queries containing set operators are called compound queries. Table 4-4 lists SQL set operators. They are fully described, including examples and restrictions on these operators, in "The UNION [ALL], INTERSECT, MINUS Operators".

SQLRF51165 Table 4-4 Set Operators

Operator	Returns
`UNION`	All distinct rows selected by either query
`UNION ALL`	All rows selected by either query, including all duplicates
`INTERSECT`	All distinct rows selected by both queries
`MINUS`	All distinct rows selected by the first query but not the second

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® Database SQL Language Reference 11g Release 2 (11.2)
Introduction to Oracle SQL
Pseudocolumns
Basic Elements of Oracle SQL
Operators
Functions
Expressions
Conditions
Common SQL DDL Clauses
SQL Queries and Subqueries
SQL Statements: ALTER CLUSTER to ALTER JAVA
SQL Statements: ALTER LIBRARY to ALTER SYSTEM
SQL Statements: ALTER TABLE to ALTER TABLESPACE
SQL Statements: ALTER TRIGGER to COMMIT
SQL Statements: CREATE CLUSTER to CREATE JAVA
SQL Statements: CREATE LIBRARY to CREATE SPFILE
SQL Statements: CREATE SYNONYM to CREATE TRIGGER
SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT
SQL Statements: DROP SEQUENCE to ROLLBACK
SQL Statements: SAVEPOINT to UPDATE
How to Read Syntax Diagrams
Automatic and Manual Locking Mechanisms During SQL Operations
Oracle and Standard SQL
Oracle Regular Expression Support
Oracle SQL Reserved Words and Keywords
Extended Examples

New and changed documents:

HTML

PDF