Oracle Database 12c R2 SQL: Using the Set Operators

Oracle SQL 12c    |    Beginner
  • 8 Videos | 40m 5s
  • Includes Assessment
  • Earns a Badge
Likes 59 Likes 59
Discover how to write SQL queries by using set operators.

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 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Likes 268 Likes 268  
COURSE Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Likes 34 Likes 34  
COURSE Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Likes 39 Likes 39  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL Developer
Likes 285 Likes 285  
COURSE Oracle Database 12c R2 SQL: Restricting & Sorting Data
Likes 25 Likes 25  
COURSE Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Likes 28 Likes 28