Filtering Rows Using the WHERE Clause

You can use the WHERE clause in a SELECT statement to filter the rows returned from the database. This is very important as Oracle has the capacity to store large numbers of rows in a table and you may only be interested in a very small subset of those rows. You place the WHERE clause after the FROM clause:

SELECT ...
FROM
WHERE ...;