Oracle SQL Revealed

Executing Business Logic in the Database Engine

  • Alex Reprintsev

Table of contents

  1. Front Matter
    Pages i-x
  2. Features and Theory

    1. Front Matter
      Pages 1-3
    2. Alex Reprintsev
      Pages 5-66
    3. Alex Reprintsev
      Pages 67-83
    4. Alex Reprintsev
      Pages 85-102
    5. Alex Reprintsev
      Pages 103-118
    6. Alex Reprintsev
      Pages 119-138
    7. Alex Reprintsev
      Pages 139-159
    8. Alex Reprintsev
      Pages 161-197
    9. Alex Reprintsev
      Pages 199-216
    10. Alex Reprintsev
      Pages 217-233
    11. Alex Reprintsev
      Pages 235-242
  3. PL/SQL and SQL solutions

    1. Front Matter
      Pages 243-244
    2. Alex Reprintsev
      Pages 245-304
    3. Alex Reprintsev
      Pages 305-379
    4. Alex Reprintsev
      Pages 381-382
  4. Back Matter
    Pages 383-389

About this book

Introduction

Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle’s power in implementing business logic, thereby maximizing return from your company’s investment in Oracle Database products.

Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and aggregate functions, and recursive subquery factoring, just to name a few. The focus is on implementing business logic in pure SQL, with a comparison of different approaches that can be used to write SELECT statements to return results that drive good decision making and competitive action in the marketplace.   

This book covers features that are often not well known, and sometimes not implemented in competing products. Chapters on query transformation and logical execution order provide a grasp of the big picture in which the individual SQL features described in the other chapters are executed. Also included are a discussion on when to use the procedural capabilities from PL/SQL, and a series of examples showing different mixes of SQL features being applied in common types of queries that you are likely to encounter. 

What You Will Learn:
  • Gain competitive advantage from Oracle SQL
  • Know when to step up to PL/SQL versus staying in SQL
  • Become familiar with query transformations and join mechanics
  • Apply the model clause and analytic functions to business intelligence queries
  • Make use of features that are specific to Oracle Database, such as row pattern matching
  • Understand the pros and cons of different SQL approaches to solving common query tasks
  • Traverse hierarchies using CONNECT BY and recursive subquery factoring

Keywords

PL/SQL MODEL clause CONNECT BY Query Transformation Analytic functions Window functions ANSI joins Row Pattern Matching Hierarchical Queries

Authors and affiliations

  • Alex Reprintsev
    • 1
  1. 1.LondonUnited Kingdom

Bibliographic information

  • DOI https://doi.org/10.1007/978-1-4842-3372-6
  • Copyright Information Alex Reprintsev 2018
  • Publisher Name Apress, Berkeley, CA
  • eBook Packages Professional and Applied Computing
  • Print ISBN 978-1-4842-3371-9
  • Online ISBN 978-1-4842-3372-6
  • About this book