Advanced SQL Functions in Oracle 10g
| Author/creator | Earp, Richard Walsh, 1940- Author |
| Other author | Bagui, Sikha Saha 1964- Author |
| Format | Electronic |
| Publication Info | Sudbury : Jones & Bartlett Publishers, Incorporated |
| Description | 397 p. ill 09.020 x 06.400 in. |
| Supplemental Content | Full text available from eBooks on EBSCOhost |
| Subjects |
| Summary | Annotation 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. |
| Access restriction | Available only to authorized users. |
| Technical details | Mode of access: World Wide Web |
| Genre/form | Electronic books. |
| LCCN | 2005036444 |
| ISBN | 9781598220216 |
| ISBN | 1598220217 (Perfect) Active Record |
| Standard identifier# | 9781598220216 |
| Stock number | 00023584 |
Availability
| Library | Location | Call Number | Status | Item Actions |
|---|---|---|---|---|
| Electronic Resources | Access Content Online | ✔ Available |