Subquery IN « Subquery « Oracle PL / SQL

1.Multiple Row Subqueries: IN with subquery
2.Multiple Row Subqueries: NOT IN with subquery
3.Not in and subquery subquery
5.All locations, where courses are offering, have no departments (subquery)
6.In and subquery
7.Multiple-row subqueries return more than one row of result from the subquery
8.Selecting Products That Belong to Department with Subquery
9.Subquery in from clause

10.Using Set Membership with Subqueries