Where « Query Select « Oracle PL/SQL Tutorial

2.3.1.Filtering Rows Using the WHERE Clause
2.3.2.A WHERE Clause Is Added to the Statement
2.3.3.Using the WHERE and GROUP BY Clauses Together
2.3.4.Convert char to number implicit in where clause
2.3.5.Compare Number type in where clause
2.3.6.where with complated boolean expressions
2.3.7.Where with sub query
2.3.8.where comm = comm, compare with itself
2.3.9.Where with count from subquery

2.3.10.Do calculation in where clause