Skip to Main Content

Visualizing SQL Pattern Matching (MATCH_RECOGNIZE) - A Beginner's Guide

Added in 12c, SQL pattern matching make it easy to search for sequences of different events across rows. But how does it work? Watch this presentation for a complete beginner's guide to match_recognize. With visualizations to show how it selects the rows, this session will teach you how to use this powerful clause. Highlights include: 02:40 - An overview of match_recognize & its clauses 08:40 - Demo of using pattern matching with one variable to find consecutive 1km runs 17:00 - Comparing results when searching for different patterns of 1km runs 27:15 - Demo searching for two variables - 1km run followed by a 5km run 35:00 - Displaying overlapping patterns in the input 39:00 - Does pattern matching replace the where clause? 42:30 - Comparing different patterns outputs when using two variables 44:30 - Classifying rows into value ranges - the limitations of regular expressions 48:30 - Demo using pattern matching to group rows into range values and calculate totals 58:10 - Why use pattern matching - example use cases Further reading: Complete Guide to SQL Pattern Matching - Volume 1 - https://books.apple.com/us/book/complete-guide-to-sql-pattern-matching-volume-1/id1302139558 SQL Pattern Matching (match_recognize) Use Cases - https://blogs.oracle.com/sql/post/ogb-appreciation-day-sql-pattern-matching-match_recognize-use-cases

Resources

Featured Speakers

  • Speaker

    Chris Saxon


    Oracle Developer Advocate for SQL

  • Speaker

    Christian Berg


    Principal Analytics Domain Specialist

Workshop Info

Session Has Completed - 15 March 2022
1 Hour
Write Great SQL Office Hours
English
SQL

Other Upcoming Sessions