SQL Pattern Matching Deep Dive - the PDF Version tháng 11 27, 2017 Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a d...
SQL Pattern Matching Deep Dive - the book tháng 11 07, 2017 Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a d...
MATCH_RECOGNIZE and predicates - everything you need to know tháng 7 17, 2017 MATCH_RECOGNIZE and predicates At a recent user conference I had a question about when and how predicates are applied when using MATCH_RECO...
Sneak preview of demo for Oracle Code events tháng 3 14, 2017 I will be presenting at a number of the Oracle Code events over the coming months on the subject of…..( drum roll please ) SQL pattern matc...
MATCH_RECOGNIZE: Can I use MATCH_NUMBER() as a filter? tháng 3 07, 2017 Recently I spotted a post on OTN that asked the question: Can MATCH_RECOGNIZE skip out of partition? This requires a bit more detail becau...
MATCH_RECOGNIZE - What should I include in the MEASURES clause? tháng 1 16, 2017 Image courtesy of wikipedia This post is the result of reviewing a post on stackoverflow.com: http://stackoverflow.com/questions/41649178/ge...
SQL Pattern Matching Deep Dive - Part 5, SKIP TO where exactly? tháng 11 09, 2016 Image courtesy of flicker.com So far in this series we looked at how to ensure query consistency, how correctly use predicates, managing s...
SQL Pattern Matching Deep Dive - Part 4, Empty matches and unmatched rows? tháng 10 11, 2016 image courtesy of flicker: https://c1.staticflickr.com/1/55/185807556_21c547c02e_b.jpg I have been asked a number of times during and after ...