Lesson 7. Advanced Data Filtering
This lesson shows you how to combine WHERE clauses to create powerful and sophisticated search conditions, and how to use the NOT and IN operators.
Combining WHERE Clauses
All the WHERE
clauses introduced in Lesson 6, “Filtering Data,” filter data on a single criterion. For a greater degree of filter control, Oracle allows you to specify multiple WHERE
clauses. You may use these clauses in two ways: as AND
clauses or as OR
clauses.
Operator
A special keyword used to join or change clauses in a WHERE
clause. Also known as logical operators.
Using the AND Operator
To filter by more than one column, you use the AND
operator to append conditions to your WHERE
clause. The following code demonstrates this:
Get Oracle PL/SQL in 10 Minutes, Sams Teach Yourself now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.