Oracle SQL recipes : a problem-solution approach / Grant Allen, Bob Bryla, and Darl Kuhn.

Format:

Book

Author/Creator:

Allen, Grant.

Contributor:

Bryla, Bob.

Kuhn, Darl.

Series:

Expert's voice in Oracle.

The expert's voice in Oracle

Language:

English

Subjects (All):

SQL (Computer program language).

Oracle (Computer file).

Physical Description:

1 online resource (564 p.)

Edition:

1st ed. 2009.

Place of Publication:

Berkeley, Calif. : Apress, c2009.

Language Note:

English

System Details:

text file

Summary:

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.

Contents:

Foundations of Data Manipulation

The Basics

Summarizing and Aggregating Data

Querying from Multiple Tables

Creating and Deriving Data

Common Query Patterns

Data Types and Their Problems

Working with Date and Time Values

Strings

Working with Numbers

Your Development Environment

Managing Transactions

Data Dictionary

Special Topics

Common Reporting Problems

Cleansing Data

Tree-Structured Data

Working with XML Data

Partitioning

LOBs

Administration

Database Administration

Object Management

SQL Monitoring and Tuning

Database Troubleshooting.

Notes:

Includes index.

ISBN:

9786612825521

9781282825529

1282825526

9781430225102

1430225106

OCLC:

535023340