Use Cases of Row Pattern Matching in Oracle 12c with Kim Berg Hansen
Update: 2017-06-17
Description
In this episode, I hosted Oracle ACE Kim Berg Hansen to talk about Use Cases of Row Pattern Matching in Oracle 12c.
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. In this session, Kim talks about row patten matching syntax, demonstration of variuos use cases where each use case highlights a different part of the SQL syntax for match recognize.
If you'd like to watch the recording of this webinar, or be notified of upcoming webinars, please register at http://www.prohuddle.com.
Comments
In Channel