Advanced SQL Functions in Oracle 10g
- 3h 15m
- Richard Walsh Earp, Sikha Saha Bagui
- Jones and Bartlett Learning
- 2006
Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions.
About the Authors
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.
In this Book
-
Common Oracle Functions—A Function Review
-
Reporting Tools in Oracle's SQL*Plus
-
The Analytical Functions in Oracle (Analytical Functions I)
-
Aggregate Functions Used as Analytical Functions (Analytical Functions II)
-
The Use of Analytical Functions in Reporting (Analytical Functions III)
-
The MODEL or SPREADSHEET Predicate in Oracle's SQL
-
Regular Expressions—String Searching and Oracle 10g
-
Collection and OO SQL in Oracle
-
SQL and XML
