Skip to content
This repository has been archived by the owner on Apr 8, 2019. It is now read-only.

Home

Jump to bottom
Keith Laker edited this page Jun 26, 2014 · 1 revision

Welcome to the analytical-sql-examples wiki!

Who am I?

Keith Laker - I am part of the Data Warehouse product management team. I have extensive experience of the data warehouse and business intelligence market having worked in a variety of roles, including: post sales consultancy, customer support and product management. Worked in a number of locations across Europe and also in California at Oracle's HQ in Redwood Shores.

Almost 15 years with Oracle. Worked in consulting, support, on-site Premium Support, and now product management. Currently I am part of ST Data Warehouse Product Management team, providing PM support to DW focused sales and Consulting services organization to help ensure the successful and effective delivery of DW solutions. Author of the data warehouse and analytical SQL blog.

What it's in this repository

The aim of this repository is to share examples of how to use the analytical SQL features of Oracle Database. Overtime the plans is to include examples covering the following SQL features:

  • SQL aggregation extensions: cube, rollup, grouping sets
  • Window functions
  • SQL Model clause
  • Pivot/Unpivot
  • Pattern Matching
  • Top-N
  • WITH clause
Clone this wiki locally