Oracle 19c SQL

  1. Home
  2. Docs
  3. Oracle 19c SQL
  4. 5 Subqueries In Oracle

5 Subqueries In Oracle

What you’ll learn in this Chapter

✓ What are Subqueries
✓ Why and where to use Subqueries?
✓ Types of Subqueries
✓ Using subqueries for data retrieval


A subquery is a SELECT query nested inside another SQL query. Subqueries can be part of SELECT/ INSERT/ UPDATE/ DELETE/ MERGE statements.
Subqueries are an essential part for any database as many real world problems would not be possible without a subquery. You’ll learn how to use subqueries with multiple scenarios in our documentation.


Was this article helpful to you? Yes No

How can we help?