Apress Access

Oracle SQL Recipes

A Problem-Solution Approach

By Grant Allen , Bob Bryla , Chris Allen , Darl Kuhn

  • eBook Price: $34.99
Buy eBook Buy Print Book
Oracle SQL Recipes is a compendium of ready-made solutions to common SQL problems for Oracle developers and database administrators.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-2509-6
  • User Level: Beginner to Advanced
  • Publication Date: November 17, 2009
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • Pro Oracle Identity and Access Management Suite
  • Mastering Oracle GoldenGate
  • Expert Oracle Indexing and Access Paths, 2nd Edition
  • Pro Oracle GoldenGate for the DBA
  • Beginning SQL Queries, 2nd Edition
  • Relational Database Programming
Full Description

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

Table of Contents

  1. The Basics
  2. Summarizing and Aggregating Data
  3. Querying from Multiple Tables
  4. Creating and Deriving Data
  5. Common Query Patterns
  6. Working with Date and Time Values
  7. Strings
  8. Working with Numbers
  9. Managing Transactions
  10. Data Dictionary
  11. Common Reporting Problems
  12. Cleansing Data
  13. Tree-Structured Data
  14. Working with XML Data
  15. Partitioning
  16. LOBs
  17. Database Administration
  18. Object Management
  19. SQL Monitoring and Tuning
  20. Database Troubleshooting
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. Pro JPA 2


      View Book

    2. Pro Oracle SQL


      View Book

    3. Beginning Oracle PL/SQL


      View Book

    4. Oracle Core: Essential Internals for DBAs and Developers


      View Book