Course Description
Discover how to write SQL queries by using set operators.
Learning Objectives
Oracle Database 12c R2 SQL: Using the Set Operators
- describe the types of set operators and their associated guidelines
- recognize how the Oracle Server manages set operators
- use UNION and UNION ALL operators to return all rows in a SQL statement
- use the INTERSECT operator to return all rows that are common to multiple queries in a SQL statement
- use the MINUS operator to return all distinct rows selected by the first query in a SQL statement
- demonstrate how the expressions in the SELECT lists of queries must match in number in a SQL statement
- use the ORDER BY clause in set operations in a SQL statement
- use set operators to combine the results of multiple queries