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

Опубликовано: 16 Март 2022
на канале: Oracle Developers
5,009
97

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


Смотрите видео Visualizing SQL Pattern Matching (MATCH_RECOGNIZE) - A Beginner's Guide онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Oracle Developers 16 Март 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,009 раз и оно понравилось 97 людям.