Correlated Subquery « Query Select « Oracle PL/SQL Tutorial






2.37.Correlated Subquery
2.37.1.Writing Correlated Subqueries
2.37.2.Using EXISTS and NOT EXISTS with a Correlated Subquery
2.37.3.A correlated subquery: the subquery references a column from a table referred to in the parent statement.
2.37.4.The subquery returning the literal value 1
2.37.5.Using NOT EXISTS with a Correlated Subquery
2.37.6.list all employees who is younger than Joe
2.37.7.List all employees who attended XML course and Java course
2.37.8.Extract a Subset of the Results
2.37.9.How Many Products By Department with correlated subqueries 1








2.37.10.How Many Products By Department with correlated subqueries 2
2.37.11.Correlated subquery using the EXISTS operator