Skip to main content
SpringerLink
Log in
Apress

Oracle SQL Recipes

A Problem-Solution Approach

  • Book
  • © 2009

Overview

Authors:
  1. Grant Allen
    View author publications

    You can also search for this author in PubMed   Google Scholar

  2. Bob Bryla
    View author publications

    You can also search for this author in PubMed   Google Scholar

  3. Darl Kuhn
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Merges the approach of two, proven successful books on SQL (the SQL Cookbook and Mastering Oracle SQL)

  • Cowritten by one of Apress’s strongest, recipe-book authors

  • Takes a solution-oriented approach that is sure to appeal to readers with problems to solve and little time to sit back and read

  • 17k Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (20 chapters)

  1. Front Matter

    Pages i-xxv
    Download chapter PDF

  2. Foundations of Data Manipulation

    1. Front Matter

      Pages 1-1
      Download chapter PDF

    2. The Basics

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 3-22

    3. Summarizing and Aggregating Data

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 23-57

    4. Querying from Multiple Tables

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 59-81

    5. Creating and Deriving Data

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 83-107

    6. Common Query Patterns

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 109-140

  3. Data Types and Their Problems

    1. Front Matter

      Pages 141-141
      Download chapter PDF

    2. Working with Date and Time Values

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 143-165

    3. Strings

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 167-186

    4. Working with Numbers

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 187-205

  4. Your Development Environment

    1. Front Matter

      Pages 207-207
      Download chapter PDF

    2. Managing Transactions

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 209-228

    3. Data Dictionary

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 229-260

  5. Special Topics

    1. Front Matter

      Pages 261-261
      Download chapter PDF

    2. Common Reporting Problems

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 263-285

    3. Cleansing Data

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 287-311

    4. Tree-Structured Data

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 313-333

    5. Working with XML Data

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 335-350

    6. Partitioning

      • Grant Allen, Bob Bryla, Darl Kuhn
      Pages 351-381
Back to top

Keywords

About this book

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

About the authors

Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator. Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance. He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android. His first Android application was a task list to remind him to finish all his other unfinished Android projects. Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments. Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation