A technical deep dive into pattern matching using MATCH_RECOGNIZE


Business Intelligence & Analytics

Date and time

Wednesday, 19. October 2016., 11:00


Hall C



This session will explore the new Database 12c SQL Pattern Matching feature. This is a very powerful feature, which can used to solve a wide variety of business and technical problems. Using a live demo we will look at how to solve typical pattern matching business problems that can be solved very efficiently using MATCH_RECOGNIZE. To help you understand the basic mechanics of the MATCH_RECOGNIZE clause the demo will look at the new MATCH_RECOGNIZE related keywords in the explain plan such as DETERMINISTIC, FINITE  and AUTO. We will explore the key concepts of deterministic vs. non-deterministic state machines, greedy vs. reluctant quantifiers and how to use the built-in debugging measures. Finally, we will review typical issues such as back-tracking.

Lecture details

Type: Lecture
Experience Level: Experienced
Desirable listeners function: All of them
Group of activity: business intelligence and Analytics

About speaker

Best Sponsor

Better Sponsor

Good Sposor

University sponsor

Media Sponsor


The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.

Follow us on Facebook

Follow us on Twitter

Keep yourself up to date with all updates!