CHAPTER 11
Subqueries and Set Operators
Exam Objectives
In this chapter, you will learn to
• 061.7.1 Define Subqueries
• 061.7.2 Describe the Types of Problems that the Subqueries Can Solve
• 061.7.3 Describe the Types of Subqueries
• 061.7.4 Write Single-Row and Multiple-Row Subqueries
• 061.8.1 Describe Set Operators
• 061.8.2 Use a Set Operator to Combine Multiple Queries into a Single Query
• 061.8.3 Control the Order of Rows Returned
The previous chapters have dealt with the SELECT statement in considerable detail, but in every case the SELECT statement has been a single, self-contained command. This chapter is the first ...
Get OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
