Mastering Oracle SQL

By Alan Beaulieu, Sanjay Mishra

Publisher : O'Reilly
Pub Date : April 2002
ISBN : 0-596-00129-0
Pages : 336
Slots : 1


Few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that. The authors cover the full range of Oracle SQL features that apply to query writing. Learn to write UNION queries that take full advantage of SQL's set orientation, and ways to use Oracle's new analytic SQL features to write ranking queries, lag and lead queries, and more.

Copyright
Dedication
Preface
Why We Wrote This Book
Objectives of This Book
Audience for This Book
Platform and Version
Structure of This Book
Conventions Used in This Book
Comments and Questions
Acknowledgments

Chapter 1. Introduction to SQL
Section 1.1. What Is SQL?
Section 1.2. A Brief History of SQL
Section 1.3. A Simple Database
Section 1.4. DML Statements

Chapter 2. The WHERE Clause
Section 2.1. Life Without WHERE
Section 2.2. WHERE to the Rescue
Section 2.3. WHERE Clause Evaluation
Section 2.4. Conditions and Expressions
Section 2.5. WHERE to Go from Here

Chapter 3. Joins
Section 3.1. Inner Joins
Section 3.2. Outer Joins
Section 3.3. Self Joins
Section 3.4. Joins and Subqueries
Section 3.5. DML Statements on a Join View
Section 3.6. ANSI-Standard Join Syntax in Oracle9i

Chapter 4. Group Operations
Section 4.1. Aggregate Functions
Section 4.2. The GROUP BY Clause
Section 4.3. The HAVING Clause

Chapter 5. Subqueries
Section 5.1. What Is a Subquery?
Section 5.2. Noncorrelated Subqueries
Section 5.3. Correlated Subqueries
Section 5.4. Inline Views
Section 5.5. Subquery Case Study: The Top N Performers

Chapter 6. Handling Temporal Data
Section 6.1. Internal DATE Storage Format
Section 6.2. Getting Dates In and Out of a Database
Section 6.3. Date Manipulation
Section 6.4. Oracle9i New DATETIME Features
Section 6.5. INTERVAL Literals

Chapter 7. Set Operations
Section 7.1. Set Operators
Section 7.2. Using Set Operations to Compare Two Tables
Section 7.3. Using NULLs in Compound Queries
Section 7.4. Rules and Restrictions on Set Operations

Chapter 8. Hierarchical Queries
Section 8.1. Representing Hierarchical Information
Section 8.2. Simple Hierarchy Operations
Section 8.3. Oracle SQL Extensions
Section 8.4. Complex Hierarchy Operations
Section 8.5. Restrictions on Hierarchical Queries

Chapter 9. DECODE and CASE
Section 9.1. DECODE, NVL, and NVL2
Section 9.2. The Case for CASE
Section 9.3. DECODE and CASE Examples

Chapter 10. Partitions, Objects, and Collections
Section 10.1. Table Partitioning
Section 10.2. Objects and Collections

Chapter 11. PL/SQL
Section 11.1. What Is PL/SQL?
Section 11.2. Procedures, Functions, and Packages
Section 11.3. Calling Stored Functions from Queries
Section 11.4. Restrictions on Calling PL/SQL from SQL
Section 11.5. Stored Functions in DML Statements
Section 11.6. The SQL Inside Your PL/SQL

Chapter 12. Advanced Group Operations
Section 12.1. ROLLUP
Section 12.2. CUBE
Section 12.3. The GROUPING Function
Section 12.4. GROUPING SETS
Section 12.5. Oracle9i Grouping Features
Section 12.6. The GROUPING_ID and GROUP_ID Functions

Chapter 13. Advanced Analytic SQL
Section 13.1. Analytic SQL Overview
Section 13.2. Ranking Functions
Section 13.3. Windowing Functions
Section 13.4. Reporting Functions
Section 13.5. Summary

Chapter 14. SQL Best Practices
Section 14.1. Know When to Use Specific Constructs
Section 14.2. Avoid Unnecessary Parsing
Section 14.3. Consider Literal SQL for Decision Support Systems

Colophon
Index

Download
Another Database Books