Advanced SQL Functions in Oracle 10g

by Dr. Richard Earp, Dr. Sikha Bagui

Overview

Designed to exploit Oracle 10g's SQL, this book takes a comprehensive look at Oracle 10g's analytical functions, MODEL statements, 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.
This text will teach the reader 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.

Product Details

ISBN-13:	9781598220216
Publisher:	Jones & Bartlett Learning
Publication date:	02/22/2006
Series:	Wordware Applications Library
Edition description:	1E
Pages:	397
Product dimensions:	5.90(w) x 8.90(h) x 0.90(d)

About the Author

Associate Professor of Computer Science, University of West Florida