What does oracle so with sql having WHERE clause?

When SQL processes theWHERE clause, it tests the value of each row in a column (or the result of each row inan expression) against a particular value. The query includes only rows that meet thecondition in the result set. For example, to return the number of tables in the databaseowned by the user SYSMAN, a DBA could issue the following query:SELECT COUNT(*) FROM DBA_TABLES WHERE OWNER = 'SYSMAN';