Subqueries are very useful when you need to select rows from a table with a condition that depends on the data in the table itself. Explore the types, syntax, and guidelines for using subqueries in Oracle.
Learning Objectives
Oracle Database 12c R2 SQL: Using Subqueries to Solve Queries
- use a subquery to solve a problem in a SQL statement
- using group functions and the HAVING clause in a subquery
- use the IN, ANY, and ALL operators in multiple-row subqueries in a SQL statement
- use a multiple-column subquery to return more than one column to the outer query in a SQL statement
- use the EXISTS and NOT EXISTS operators
- use the WITH clause
- use correlated UPDATE subqueries
- use correlated DELETE subqueries
- use the WITH CHECK OPTION
- demonstrate the use of NULL values in a subquery and use the NOT IN operator in a SQL statement
- manipulate data using subqueries