© Ben Brumm 2019
Ben BrummBeginning Oracle SQL for Oracle Database 18chttps://doi.org/10.1007/978-1-4842-4430-2_10

10. Applying Filters on Lists and Ranges of Values

Ben Brumm1 
Melbourne, VIC, Australia

In previous chapters, you learned about the WHERE clause and how you could use it to restrict the results you see. You can do this using a variety of symbols, called operators , such as “equal to” and “less than.” You can also specify multiple criteria using the AND/OR keywords.

Working with lists of values presents an interesting challenge in that a large list can result in a large number of AND and OR keywords in a query. This chapter introduces some syntax that’s helpful when working with large lists. You’ll also learn about some syntax for ...

Get Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional 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.