Advanced SQL Functions in Oracle 10g (Wordware Applications Library) (Paperback)

by Richard Earp (Author), Sikha Bagui (Author) "Oracle functions operate on "appropriate data" to transform a value to another value..." (more)
Key Phrases: numerical manipulation functions, analytic clause, employee with nulls, Lumber Pensacola, Cotton Pensacola, Greenbrier Blvd (more...)

Editorial Reviews

Product 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, Advanced SQL Functions in Oracle 10g 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.

About the Author
Dr. Richard Walsh Earp is a former chair of and former associate professor in the Department of Computer Science and a former dean of the College of Science and Technology at the University of West Florida in Pensacola. He has taught a variety of computer science courses including database systems and advanced database systems. Dr. Earp was also an instructor with Learning Tree International and worked for Computer Sciences Corporation at the Naval Air Station in Pensacola as a database consultant after his retirement from academia. He has co-authored several books with Dr. Bagui.

Dr. Sikha Saha Bagui is an assistant professor in the Department of Computer Science at the University of West Florida. She teaches a variety of computer science courses and conducts research on database design, data mining, pattern recognition, and statistical computing. Dr. Bagui has published many journal articles and co-authored several books with Dr. Earp: Learning SQL: A Step-by-Step Guide Using Oracle, Database Design Using ER Diagrams, and Learning SQL: A Step-by-Step Guide Using Access.

Product Details

• Paperback: 416 pages
• Publisher: Jones & Bartlett Publishers; 1 edition (February 8, 2006)
• Language: English
• ISBN-10: 1598220217
• ISBN-13: 978-1598220216
• Product Dimensions: 8.9 x 5.9 x 0.9 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars See all reviews (2 customer reviews)
• Amazon.com Sales Rank: #433,978 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #18 in	Books > Computers & Internet > Databases > Oracle > SQL
  #40 in	Books > Computers & Internet > Databases > Oracle > PL & SQL

Customer Reviews

Most Helpful Customer Reviews

5.0 out of 5 stars Raising Your Game, April 25, 2009

By	Ben Bartholic "BB" (Houston, Texas) - See all my reviews (REAL NAME)

This book is a must have if you do any kind of work with Oracle. Before reading this book, I thought I knew a lot about SQL, but this book absolutely raised my game to another level. This book does read a little like a dictionary, but it is packed from cover to cover with useful techniques that you will use every day, and is small enough to be kept at your desk for easy reference. This book mainly sticks to the analytical tools Oracle offers so if you build reports, analyze data, forecast trends, or work in any kind of decision science department do yourself a favor and get this book.

3 of 5 people found the following review helpful:

3.0 out of 5 stars Not that advanced and has some errors, September 28, 2007

By	A. Rodriguez "Arturo Rodriguez" (Virginia, USA) - See all my reviews (REAL NAME)

I found a few errors and most chapters lack details.

In the 'model clause chapter' for example, more is needed for :
REFERENCE MODELs,
ITERATIVE MODELs (ITERATION_NUMBER (0-4294967295), PREVIOUS(), etc),
FOR LOOPs,
IS PRESENT,
ETC.

Also, more can be discussed for GROUPING_ID and GROUP_ID() and many other additions to advanced features such as hierarchical queries, analytical functions and others.