Kim Berg Hansen

Oracle ACE

Use Cases of Row Pattern Matching in Oracle 12c
About the Webinar

Pattern recognition has many use cases such as finding ups and downs in values over time (e.g. stock tickers), detecting fraudulent behaviour, grouping consecutive data, finding gaps, finding or merging overlapping periods and calculating number of children in hierarchical data.

This webinar will cover the following topics:

About the Presenter

Kim Berg Hansen is an Oracle ACE in Database Development and an Oracle Certified Expert on SQL. He works as a senior developer at Trivadis AG.

He is the main author for the weekly “Select from SQL” quiz on Oracle PL/SQL Challenge at He blogs on Oracle development topics, mainly SQL, at

In his spare time, he likes to cook and read sci-fi. He is the local chapter chairman of the Danish Beer Enthusiasts Association.