1. Home
  2. SQL
  3. Mastering Oracle SQL

Platform and Version

We used Oracle Database 10g in writing this book. We've covered many of Oracle Database 10g's important new SQL features, including regular expressions, hierarchical query features, object and collection functionality, and interrow calculations. Most of the concepts, syntax, and examples apply to earlier releases of Oracle as well. We specifically point out the new Oracle Database 10g features.



    		Mastering Oracle SQL, 2nd Edition
    		Preface
    		Why We Wrote This Book
    		What's New in Oracle SQL?
    		Objectives of This Book
    		Audience for This Book
    		Platform and Version
    		Structure of This Book
    		Conventions Used in This Book
    		Using Code Examples
    		Comments and Questions
    		Acknowledgments
    		Chapter 1. Introduction to SQL
    		Chapter 2. The WHERE Clause
    		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