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.
This item is Non-Returnable
Customers Also Bought
Details
- ISBN-13: 9781598220216
- ISBN-10: 1598220217
- Publisher: Jones & Bartlett Publishers
- Publish Date: February 2006
- Dimensions: 9.02 x 6.4 x 0.9 inches
- Shipping Weight: 1.23 pounds
- Page Count: 397
Related Categories
