1. Home
  2. SQL
  3. Mastering Oracle SQL

Chapter 2. The WHERE Clause

Whether you are querying, modifying, or deleting data, the WHERE clause is the mechanism for identifying what data you want to work with. This chapter explores the role of the WHERE clause in SQL statements, as well as the various options available when building a WHERE clause.



    		Mastering Oracle SQL, 2nd Edition
    		Preface
    		Chapter 1. Introduction to SQL
    		Chapter 2. The WHERE Clause
    		2.1 Life Without WHERE
    		2.2 WHERE to the Rescue
    		2.3 WHERE Clause Evaluation
    		2.4 Conditions and Expressions
    		2.5 WHERE to Go from Here
    		Chapter 3. Joins
    		Chapter 4. Group Operations
    		Chapter 5. Subqueries
    		Chapter 6. Handling Temporal Data
    		Chapter 7. Set Operations
    		Chapter 8. Hierarchical Queries
    		Chapter 9. DECODE and CASE
    		Chapter 10. Partitioning
    		Chapter 11. PL/SQL
    		Chapter 12. Objects and Collections
    		Chapter 13. Advanced Group Operations
    		Chapter 14. Advanced Analytic SQL
    		Chapter 15. SQL Best Practices
    		Chapter 16. XML
    		Chapter 17. Regular Expressions
    		Chapter 18. Model Queries
    		Appendix A. Oracle's Old Join Syntax
    		Colophon