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.