This tag should be used with questions the SQL MATCH_RECOGNIZE clause
Oracle 12c introduced a powerful pattern matching feature that works similar to the MODEL clause, syntactically. For example, we can write queries like:
SELECT *
FROM series
MATCH_RECOGNIZE (
ORDER BY id
MEASURES classifier() AS trg
ALL ROWS PER MATCH
PATTERN (S (R X R+)?)
DEFINE
R AS sign(R.amount) = prev(sign(R.amount)),
X AS sign(X.amount) = prev(sign(X.amount))
)
