O'Reilly logo

Oracle Database 11g SQL: Master SQL and PL/SQL in the Oracle Database by Jason Price

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 6Subqueries

All the queries you’ve seen so far in this book have contained just one SELECT statement. In this chapter, you will learn the following:

Image How to place an inner SELECT statement within an outer SELECT, UPDATE, or DELETE statement. The inner SELECT is known as a subquery.

Image The features of the different types of subqueries.

Image How subqueries allow you to build up very complex statements from simple components.

Types of Subqueries

There ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required