Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your side.

    * Example-based, providing quality solutions to everyday problems
    * Respects your time by putting solutions first and keeping discussions short
    * Solves the most commonly encountered SQL problems


What you'll learn

    * Recognize common query patterns and apply their corresponding solutions.
    * Solve common reporting problems such as sorting rows into buckets.
    * Troubleshoot SQL performance problems.
    * Create and manage database objects such as tables, indexes, and views.
    * Work with XML and tree-structured data.
    * Take advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL.