Advanced SQL Functions in Oracle 10g

Dr. Richard Earp, Dr. Sikha Bagui (Autoren)

Buch | Softcover

397 Seiten

2006
Jones and Bartlett Publishers, Inc (Verlag)
978-1-59822-021-6 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

Designed to exploit Oracle 10g's SQL, this book takes a look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. It also covers collection/object-oriented structures and introduces Oracle 10g topics like SQL, XML, and statistical functions. It assumes some knowledge of SQL and is not intended as a SQL primer.

Designed to exploit Oracle g's SQL, this book takes a comprehensive look at Oracle g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection objects and object-oriented structures and introduces new Oracle g 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.

Associate Professor of Computer Science, University of West Florida

Verlagsort	Sudbury
Sprache	englisch
Gewicht	595 g
Themenwelt	Informatik ► Datenbanken ► Oracle
Themenwelt	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	1-59822-021-7 / 1598220217
ISBN-13	978-1-59822-021-6 / 9781598220216
Zustand	Neuware