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.

Structured Query Language Has Become The Standard For Generating, Manipulating, And Retrieving Database Information. The Dramatic Increase In The Popularity Of Relational Databases, Coupled With Oracle'S Having The Largest Market Share, Has Created A Demand For Programmers Who Can Write SQL Code Correctly And Efficiently. This Book Provides A Systematic Approach To Learning SQL In Oracle. Each Chapter Is Written In A Step-By-Step Manner And Includes Examples That Can Be Run Using Oracle. Using The Sample Tables And Data Provided, Readers Will Be Able To Perform The Examples To Gain Hands-On...