Correlated Subquery « Subquery « Oracle PL / SQL

1.A correlated subquery references one or more columns in the outer query
2.Using EXISTS with a Correlated Subquery
3.Using NOT EXISTS with a Correlated Subquery
4.Inner query Demo
5.Get Categories and Products (with Correlated Subqueries)
6.A correlated subquery: the subquery references a column from a table referred to in the parent statement.
7.How Many Products By Department with correlated subqueries 2
8.To delete the records of emps whose salary is below the average salary in the department (correlated subquery):
9.To update the salary of all emps to the maximum salary in the corresponding department (correlated subquery):