Скачать с ютуб Oracle SQL Pattern Matching Made Easy в хорошем качестве

Oracle SQL Pattern Matching Made Easy

#JoelKallmanDay 2022 A new clause – MATCH_RECOGNIZE – was added to the SELECT statement in Oracle 12c, to allow recognizing patterns in sequences of rows. This new capability is very powerful, and introduces a completely new (yet somewhat intimidating) syntax. It allows solving a variety of problems in a simpler way than before, and with better performance. In this session we focus on this new feature, understand its syntax (and see that it's not as difficult as it seems), learn how to use it and see many useful examples. Follow me on Twitter: https://twitter.com/intent/follow?screen_n... Visit my blog: https://db-oriented.com Chapters 00:00 Introduction 04:25 Eurovision 101 05:19 Patterns and Variables 11:07 Pattern Quantifiers 13:15 MATCH_NUMBER 14:45 Input and Output Recordsets 15:53 Multiple Pattern Variables 19:17 Physical Navigation and Qualifiers 25:10 CLASSIFIER 26:11 WITH UNMATCHED ROWS 26:56 AFTER MATCH SKIP 30:37 ONE ROW PER MATCH, Logical Navigation, and Aggregate Functions 33:37 SUBSET 35:30 Additional Resources Additional Resources about Pattern Matching The Documentation: https://docs.oracle.com/en/database/oracle... Keith Laker’s blog: https://oracle-big-data.blogspot.com/ Stew Ashton’s blog: https://stewashton.wordpress.com/category/... Chris Saxon’s presentations: https://www.google.com/search?q=chris+saxo... Kim Berg Hansen's book: Practical Oracle SQL https://www.amazon.com/Practical-Oracle-SQ...