Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query—including new features from Oracle versions 9i, 10g, and 11g—this guide will help information technology managers and programmers alike to gain new insight into complex queries, advanced aggregation, and analytics techniques. Introducing Model and XML as new ways to retrieve data out of the database, this sourcebook culminates as a perfect companion for advanced programmers and Oracle experts.