Oracle SQL Recipes

A Problem-Solution Approach

  • Authors
  • Grant Allen
  • Bob Bryla
  • Darl Kuhn

Table of contents

  1. Front Matter
    Pages i-xxv
  2. Foundations of Data Manipulation

    1. Front Matter
      Pages 1-1
    2. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 3-22
    3. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 23-57
    4. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 59-81
    5. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 83-107
    6. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 109-140
  3. Data Types and Their Problems

    1. Front Matter
      Pages 141-141
    2. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 143-165
    3. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 167-186
    4. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 187-205
  4. Your Development Environment

    1. Front Matter
      Pages 207-207
    2. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 209-228
    3. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 229-260
  5. Special Topics

    1. Front Matter
      Pages 261-261
    2. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 263-285
    3. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 287-311
    4. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 313-333
    5. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 335-350
    6. Grant Allen, Bob Bryla, Darl Kuhn
      Pages 351-381

About this book

Introduction

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

Keywords

Oracle SQL XML database database administration management optimization performance reporting time

Bibliographic information