IN « Query Select « Oracle PL/SQL Tutorial

2.17.1.Using the IN Operator
2.17.2.Use null value with IN operator
2.17.3.Use varchar2 type value with IN operator
2.17.4.Use in with subquery
2.17.5.Map pair with subquery by using IN operator
2.17.6.Get all managers
2.17.7.List all non-manager employee
2.17.8.Combine subquery and other conditions
2.17.9.Subquery and update statement

2.17.10.In subquery
2.17.11.In and subquery
2.17.12.Value pair and in operator