OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

9

Using Subqueries to Solve Queries

CERTIFICATION OBJECTIVES

9.01     Define Subqueries

9.02     Describe the Types of Problems Subqueries Can Solve

9.03     Describe the Types of Subqueries

9.04     Query Data Using Correlated Subqueries

9.05     Update and Delete Rows Using Correlated Subqueries

9.06     Use the EXISTS and NOT EXISTS Operators

9.07     Use the WITH Clause

9.08     Write Single-Row and Multiple-Row Subqueries

   ✓        Two-Minute Drill

Q&A     Self Test

This chapter looks at subqueries. A subquery is a SELECT statement within a larger SQL statement. The subquery concept builds on many of the features we’ve already looked at ...