•  Table of Contents •  Index •  Reviews •  Examples •  Reader Reviews •  Errata	Mastering Oracle SQL By Alan Beaulieu, Sanjay Mishra   Publisher : O'Reilly Pub Date : April 2002 ISBN : 0-596-00129-0 Pages : 336 Slots : 1

		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