Advanced SQL Functions in Oracle 10g Paperback / softback
by Dr. Richard Earp, Dr. Sikha Bagui
Paperback / softback
- Information
Description
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.
Information
-
Unavailable
- Format:Paperback / softback
- Pages:397 pages
- Publisher:Jones and Bartlett Publishers, Inc
- Publication Date:22/02/2006
- Category:
- ISBN:9781598220216
Information
-
Unavailable
- Format:Paperback / softback
- Pages:397 pages
- Publisher:Jones and Bartlett Publishers, Inc
- Publication Date:22/02/2006
- Category:
- ISBN:9781598220216