Advanced SQL Functions in Oracle 10g

Description

Designed to exploit Oracle 10g's SQL, this book takes a comprehensive look at Oracle 10g's analytical functions, MODEL state-ments, and regular expressions.

In addition, the book covers collection objects and object-oriented structures and introduces new Oracle 10g topics such as XML and statistical functions.

The authors' logical and developmental approach to query building includes a review of older Oracle tools to help in the transition to newer material.
Learn how to:
*Format result sets with SQL*Plus reporting tools.
*Use aggregate functions for partitioning, ordering, and reporting.
*Perform calculations with the MODEL statement.
*Search within strings using regular expressions.
*Work with collection objects.
*Handle XML within SQL.

Chapter 1 - Common Oracle Functions: A Function Review
Chapter 2 - Reporting Tools in Oracle's SQL*Plus
Chapter 3 - The Analytical Functions in Oracle
Chapter 4 - Aggregate Functions Used as Analytical Functions
Chapter 5 - The Use of Analytical Functions in Reporting (Analytical Functions III)
Chapter 6 - The MODEL or SPREADSHEET Predicate in Oracle's SQL
Chapter 7 - Regular Expressions: String Searching and Oracle 10g
Chapter 8 - Collection and OO SQL in Oracle
Chapter 9 - SQL and XML

Appendix A - String Functions

Appendix B - Statistical Functions

Index