Oracle Database 12c R2 SQL: Using the Set Operators


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

Discover how to write SQL queries by using set operators.



Expected Duration (hours)
0.7

Lesson 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

    • Course Number:
    it_dfosfd_06_enus

    Expertise Level
    Beginner