MATCH_NUMBER

Oracle

MATCH_NUMBER()

Example

SELECT *
FROM ticker MATCH_RECOGNIZE (
    PARTITION BY symbol ORDER BY tstamp
    MEASURES MATCH_NUMBER() AS match_no
    ALL ROWS PER MATCH
    PATTERN (down+ up+)
    DEFINE
        down AS price < PREV(price),
        up AS price > PREV(price)
);