MATCH_NUMBER

Oracle

Example

SELECT MATCH_NUMBER() OVER ()
FROM dual;

Output

MATCH_NUMBER() OVER ()
--------------------------
                   1

Explanation

In this example, the MATCH_NUMBER function is used to provide a unique number for each match generated by a pattern within a MATCH_RECOGNIZE clause. As the MATCH_RECOGNIZE clause is not used in this query, default match number returned is 1.