Working with SET Operators
Oracle 12c
| Beginner
- 8 videos | 26m 18s
- Earns a Badge
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
-
1. Types of Set Operators2m 46sAfter completing this video, you will be able to describe the types of set operators and their associated guidelines. FREE ACCESS
-
2. Oracle Server and Set Operators4m 24sAfter completing this video, you will be able to recognize how the Oracle Server manages set operators. FREE ACCESS
-
3. UNION and UNION ALL Operators3m 6sFind out how to use the UNION and UNION ALL operators to return all rows in a SQL statement. FREE ACCESS
-
4. INTERSECT Operator2m 49sIn this video, you will use the INTERSECT operator to return all rows that are common to multiple queries in a SQL statement. FREE ACCESS
-
5. MINUS Operator2m 29sIn 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
-
6. Matching SELECT Statements3m 7sAfter 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
-
7. Using the ORDER BY Clause in Set Operations2m 8sFind out how to use the ORDER BY clause in set operations in a SQL statement. FREE ACCESS
-
8. Exercise: Write Reports Using the Set Operators5m 29sFind 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.
