Advanced SQL Functions in Oracle 10g - Dr. Richard Earp, Dr. Sikha Bagui

Advanced SQL Functions in Oracle 10g

Buch | Softcover
397 Seiten
2006
Jones and Bartlett Publishers, Inc (Verlag)
978-1-59822-021-6 (ISBN)
47,35 inkl. MwSt
  • 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 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.

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 associate professor in the Department of Computer Science at the University of West Florida. She teaches a variety of computer science and database courses, and her research areas of concentration are database design, web databases, data mining, and statistical computing. Dr. Bagui has published many journal articles and co-authored several books with Dr. Earp including Practical Guide to using SQL in Oracle.

Verlagsort Sudbury
Sprache englisch
Gewicht 595 g
Themenwelt Informatik Datenbanken Oracle
Mathematik / Informatik Informatik Software Entwicklung
ISBN-10 1-59822-021-7 / 1598220217
ISBN-13 978-1-59822-021-6 / 9781598220216
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Das umfassende Praxis-Handbuch

von Lutz Fröhlich

Buch | Hardcover (2021)
MITP (Verlag)
29,99
building resilient database solutions for continuous operation

von Stephen Morris

Buch | Softcover (2023)
O'Reilly Media (Verlag)
79,80