Oracle Subqueries
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Have you viewed the Library's main Table of Contents? If not ... [Click Here] ... scroll down the page and you will find links to the largest collection of Oracle Database demos on the net.
Purpose Subqueries, in Oracle, are nothing more than queries within queries and they can be present in the SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY clauses. Subqueries can not only be used essentially anywhere they come in a wide number of variations many of which are named such as SIMPLE, CORRELATED, SCALAR, INLINE, and NESTED.

Examples of subqueries can be found throughout the Library but the following links point to places in the Library where you are going to find specific examples of subquery usage that should acquaint you with most of the constructs.

Related Topics
EXISTS Condition
Inline Views
Membership Conditions (IN and NOT IN)
SELECT Statements
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved