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/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions. The book uses a logical and developmental viewpoint approach to query building and includes a review of older Oracle tools to help in the transition to newer material. The book assumes some knowledge of SQL and is not intended as a SQL primer.