Introduction to solving SQL problems with MATCH_RECOGNIZE
Published on: Author: Team Communication Category: NewsWe are hosting a new series of live webinars: Qualogy’s Tech Series. Featuring weekly live webinars from a wide range of tech experts. The presentations can be followed via Zoom and start at 4:00 p.m. CET. On February 2, Keith Laker presents ‘Introduction to solving SQL problems with MATCH_RECOGNIZE’.
Abstract presentation
Oracle Database provides a completely new native SQL syntax that allows you to implement a core set of rules to define patterns in sequences (streams of rows). This presentation will provide a detailed review of the new keywords that make up the new MATCH_RECOGNIZE clause. It will layout a simple four step approach to writing pattern matching queries based around the main key words. A live demonstration will show how easy it is to write and amend MATCH_RECOGNIZE statements.
At the end of this session you should be able to:
- Understand how to use the MATCH_RECOGNIZE clause
- Have a good understanding of the main keywords
- Understand how SQL pattern matching can solve common business and technical problems
- Compare and contrast existing pre-12c SQL code with MATCH_RECOGNIZE statement
About Keith Laker
Keith is Product Manager for Autonomous Database and Analytic SQL with extensive experience of data warehouse and business intelligence 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 US.
He works with Oracle for almost 20 years. In consulting, support, on-site Premium Support, and now product management. Currently he is 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.
Connect with Keith via Twitter.
