Working with SET Operators

Oracle 12c    |    Beginner
  • 8 videos | 26m 18s
  • Earns a Badge
Rating 4.6 of 182 users Rating 4.6 of 182 users (182)
SET operators allow you to combine the results of two queries into one. Learn how to use SET operators and match SELECT statements in Oracle Database 12c.

WHAT YOU WILL LEARN

  • Describe the types of set operators and their associated guidelines
    Recognize how the oracle server manages set operators
    Use union and union all operators returns 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
    Describe how the expressions in the select lists of the queries must match in number in a sql statement
    Use the order by clause in set operations in a sql statement
    Write reports requested by the hr department using the set operators

IN THIS COURSE

  • Locked
    1.  Types of Set Operators
    2m 46s
    After completing this video, you will be able to describe the types of set operators and their associated guidelines. FREE ACCESS
  • Locked
    2.  Oracle Server and Set Operators
    4m 24s
    After completing this video, you will be able to recognize how the Oracle Server manages set operators. FREE ACCESS
  • Locked
    3.  UNION and UNION ALL Operators
    3m 6s
    Find out how to use the UNION and UNION ALL operators to return all rows in a SQL statement. FREE ACCESS
  • Locked
    4.  INTERSECT Operator
    2m 49s
    In this video, you will use the INTERSECT operator to return all rows that are common to multiple queries in a SQL statement. FREE ACCESS
  • Locked
    5.  MINUS Operator
    2m 29s
    In this video, learn how to use the MINUS operator to return all distinct rows selected by the first query in a SQL statement. FREE ACCESS
  • Locked
    6.  Matching SELECT Statements
    3m 7s
    After completing this video, you will be able to describe how the expressions in the SELECT lists of the queries must match in number in a SQL statement. FREE ACCESS
  • Locked
    7.  Using the ORDER BY Clause in Set Operations
    2m 8s
    Find out how to use the ORDER BY clause in set operations in a SQL statement. FREE ACCESS
  • Locked
    8.  Exercise: Write Reports Using the Set Operators
    5m 29s
    Find out how to write reports requested by the HR department using the SET operators. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 86 users Rating 4.7 of 86 users (86)
Course Oracle Database 12c R2 SQL: Data Manipulation Language & Transaction Control Language
Rating 4.6 of 74 users Rating 4.6 of 74 users (74)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Customizing Output
Rating 4.7 of 168 users Rating 4.7 of 168 users (168)
Course Data Conversion
Rating 4.6 of 203 users Rating 4.6 of 203 users (203)
Course Aggregating Data
Rating 4.7 of 152 users Rating 4.7 of 152 users (152)