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.
FREE Two-Day Shipping for students on millions of items. Learn more |
| |||||||||||||||
Book Description
Special Offers and Product Promotions
- Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)
Frequently Bought Together
Editorial Reviews
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
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
5.0 out of 5 stars
Raising Your Game,
By
Amazon Verified Purchase(What's this?)
This review is from: Advanced SQL Functions in Oracle 10g (Wordware Applications Library) (Paperback)
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,
By
Amazon Verified Purchase(What's this?)
This review is from: Advanced SQL Functions in Oracle 10g (Wordware Applications Library) (Paperback)
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.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
Oracle functions operate on "appropriate data" to transform a value to another value. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
numerical manipulation functions, analytic clause, employee with nulls, address obj, new amt, mem type, stat test, function illustrator, sub integer, salary desc, function mult, table alias, repeat operator, nulls last, invalid identifier, partition clause, club values, test statistic value, virtual table, dual which, row objects, updated rows, date data type, dependent object, original salary Key Phrases - Capitalized Phrases (CAPs): (learn more)
Lumber Pensacola, Cotton Pensacola, Greenbrier Blvd, One First Drive, Springhill Ave, Cotton Mobile, Lumber Mobile, Plastic Mobile, Blueberries Pensacola, Name Null, John Edward, Director Personnel, Gulf Breeze, Smith Programmer, Plastic Pensacola, Computer Programmer, Joe Smith, Chuck Charles, Mobile Cotton, Mobile Lumber, Redwood Shores, Grass Valley, Idaho Falls, Jones Engineer, New Milford New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Oracle functions operate on "appropriate data" to transform a value to another value. Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
numerical manipulation functions, analytic clause, employee with nulls, address obj, new amt, mem type, stat test, function illustrator, sub integer, salary desc, function mult, table alias, repeat operator, nulls last, invalid identifier, partition clause, club values, test statistic value, virtual table, dual which, row objects, updated rows, date data type, dependent object, original salary Key Phrases - Capitalized Phrases (CAPs): (learn more)
Lumber Pensacola, Cotton Pensacola, Greenbrier Blvd, One First Drive, Springhill Ave, Cotton Mobile, Lumber Mobile, Plastic Mobile, Blueberries Pensacola, Name Null, John Edward, Director Personnel, Gulf Breeze, Smith Programmer, Plastic Pensacola, Computer Programmer, Joe Smith, Chuck Charles, Mobile Cotton, Mobile Lumber, Redwood Shores, Grass Valley, Idaho Falls, Jones Engineer, New Milford New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Citations (learn more)
This book cites 1
book:
- Database Systems: The Complete Book (GOAL Series) by Hector Garcia-Molina on page 335
Books on Related Topics
(learn more)
|
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
