Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why MATCH_RECOGNIZE is used for?

ronald_2017May 10 2021

Hello All,

I am trying to learn that in which situations do you use MATCH_RECOGNIZE? What can we do with using MATCH_RECOGNIZE that we cannot with analytic functions or windowing functions?

Also, is this a different kind of model clause?

https://www.oracle.com/technetwork/database/bi-datawarehousing/mr-deep-dive-3769287.pdf

Thanks

This post has been answered by Frank Kulash on May 10 2021
Jump to Answer
Comments
Post Details
Added on May 10 2021
5 comments
275 views