How to Find Patterns in Your Data with SQL


Development & Middleware

Date and time

Thursday, 17. October 2019., 11:20


Hall E



SQL is a powerful language for accessing data. Using analytic functions, you can gain lots of insights from your data. But there are many problems which are hard or outright impossible to solve using these.

Introduced in 12c, the row pattern matching clause, match_recognize, fills this gap. With this it's easy to write efficient SQL to answer many previously tricky questions.

This session introduces the match_recognize clause. It will use worked examples to show how it works and show how it's easier to write and understand than traditional SQL solutions.


This talk is for developers and data analysts that need to do advanced data analysis.

Lecture details

Type: Lecture
Level of difficulty: Detailed
Experience Level: Experienced
Desirable listeners function: Developers , DBA

About speaker

The Best Sponsor

Better Sponsor

Educational Sponsor

Media Sponsor

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

Follow us on Twitter

Keep yourself up to date with all updates!

Follow us on Facebook