did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9781598220216

Advanced SQL Functions in Oracle 10g

by ;
  • ISBN13:

    9781598220216

  • ISBN10:

    1598220217

  • Format: Paperback
  • Copyright: 2006-02-22
  • Publisher: Jones & Bartlett Learning
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $44.95 Save up to $0.22
  • Buy New
    $44.73
    Add to Cart Free Shipping Icon Free Shipping

    PRINT ON DEMAND: 2-4 WEEKS. THIS ITEM CANNOT BE CANCELLED OR RETURNED.

Supplemental Materials

What is included with this book?

Summary

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.

Author Biography

Sikha Saha Bagui is an assistant professor in the Department of Computer Science at the University of West Florida.

Table of Contents

Common Oracle functions : a function reviewp. 1
Reporting tools in Oracle's SQL* plusp. 31
The analytical functions in Oracle (analytical functions I)p. 53
Aggregate functions used as analytical functions (analytical functions II)p. 111
The use of analytical functions in reporting (analytical functions III)p. 149
The MODEL or SPREADSHEET predicate in Oracle's SQLp. 165
Regular expressions : string searching and Oracle 10gp. 223
Collection and OO SQL in Oraclep. 269
SQL and XMLp. 337
String functionsp. 357
Statistical functionsp. 371
Table of Contents provided by Blackwell. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program