OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition

CERTIFICATION OBJECTIVES

9.01   Describe the Set Operators

9.02   Use a Set Operator to Combine Multiple Queries into a Single Query

9.03   Control the Order of Rows Returned

       Two-Minute Drill

Q&A  Self Test

All SELECT statements return a set of rows. The set operators take as their input the results of two or more SELECT statements and from these generate a single result set. This is known as a compound query. Oracle provides three set operators: UNION, INTERSECT, and MINUS. UNION can be qualified with ALL. There is a significant deviation ...