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 ...

Get OCA Oracle Database 11g SQL Fundamentals I Exam Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.