Working with SET Operators

Oracle 12c
  • 8 Videos | 27m 48s
  • Earns a Badge
Likes 31 Likes 31
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

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 Subqueries to Solve Queries 
Likes 21 Likes 21  
COURSE Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Likes 32 Likes 32  
COURSE Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Likes 165 Likes 165  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Customizing Output
Likes 53 Likes 53  
COURSE Working with DDL
Likes 57 Likes 57  
COURSE SQL Developer
Likes 152 Likes 152