image
CERTIFICATION OBJECTIVES
8.01   Define Subqueries
8.02   Describe the Types of Problems That the Subqueries Can Solve
8.03   List the Types of Subqueries
8.04   Write Single-Row and Multiple-Row Subqueries
   image    Two-Minute Drill
Q&A  Self Test
The previous six 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 of two that show how two or more SELECT commands can be combined into one statement. The first technique (covered ...

Get OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 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.

Start your free trial