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.