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 guidelinesrecognize how the Oracle Server manages set operatorsuse UNION and UNION ALL operators returns all rows in a SQL statementuse 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 statementdescribe how the expressions in the SELECT lists of the queries must match in number in a SQL statementuse the ORDER BY clause in set operations in a SQL statementwrite reports requested by the HR department using the SET operators
IN THIS COURSE
-
1.Types of Set Operators2m 46s
-
2.Oracle Server and Set Operators4m 24s
-
3.UNION and UNION ALL Operators3m 6s
-
4.INTERSECT Operator2m 49s
-
5.MINUS Operator2m 29s
-
6.Matching SELECT Statements3m 7s
-
7.Using the ORDER BY Clause in Set Operations2m 8s
-
8.Exercise: Write Reports Using the Set Operators5m 29s
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.