Complete Guide to SQL Pattern Matching - Volume 1

The first volume of this two-book series provides a gentle introduction to the new MATCH_RECGONIZE clause. In Chapter 2 I review some of the customer use cases that we collected during the functional specification phase when we were designing and building this feature. They are excellent examples of the types of business problems linked to pattern matching.


The deep dive sections of this two-book series (Chapters 4 and 5 in this volume and the whole of Volume 2) are based on a presentation that I put together for one of the annual BIWA conferences at Oracle HQ which then led to a long running series of blog posts.


The presentation started life about a year earlier as a blog post covering some of the new keywords linked to pattern matching that appear in the explain plan. The original BIWA presentation and the blog posts have now expanded to cover a much wider range of deep dive topics.


These two eBooks brings all this content together in one place. I expect both Volume 1 and 2 will be extremely useful for both SQL developers and DBAs who are new to SQL pattern matching.