Oracle SQL Recipes : A Problem-Solution Approach - Grant Allen

Oracle SQL Recipes

A Problem-Solution Approach

By: Grant Allen, Bob Bryla, Darl Kuhn

Paperback | 20 November 2009

At a Glance

Paperback


RRP $92.75

$88.75

or 4 interest-free payments of $22.19 with

 or 

Aims to ship in 10 to 15 business days

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. Who this book is for Oracle SQL Recipes is written for developers and database administrators who write SQL to run against an Oracle database. It is further written for those whose time is precious, and who just wish for a good example to help them get on with their work. If you want to spend your time writing SQL rather than reading about it, then this is the right book for you. Table of Contents * The Basics * Summarizing and Aggregating Data * Querying from Multiple Tables * Creating and Deriving Data * Common Query Patterns * Working with Date and Time Values * Strings * Working with Numbers * Managing Transactions * Data Dictionary * Common Reporting Problems * Cleansing Data * Tree-Structured Data * Working with XML Data * Partitioning * LOBs * Database Administration * Object Management * SQL Monitoring and Tuning * Database Troubleshooting

More in Databases

Python All-in-One For Dummies : 3rd Edition - John C. Shovic

RRP $74.95

$50.35

33%
OFF
Microsoft Power BI For Dummies : For Dummies (Computer/Tech) - Jack A. Hyman
Data Analytics for Accounting ISE : 3rd Edition - Vernon Richardson

RRP $159.95

$133.90

16%
OFF
Learning Spark : Lightning-Fast Data Analytics - Jules S. Damji

RRP $152.00

$69.80

54%
OFF
Python in a Nutshell : A Desktop Quick Reference - Alex Martelli

RRP $136.80

$59.90

56%
OFF
SQL Tuning : O'Reilly Ser. - Dan Tow

RRP $60.80

$29.25

52%
OFF
Information Modeling and Relational Databases : 2nd Edition - Terry Halpin
Advancing into Analytics : From Excel to Python and R - George Mount