Visualizing SQL Pattern Matching (MATCH_RECOGNIZE) - A Beginner's Guide скачать в хорошем качестве

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/compl... SQL Pattern Matching (match_recognize) Use Cases - https://blogs.oracle.com/sql/post/ogb...