Home
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.
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