The MATCH_RECOGNIZE clause enables native SQL queries to match specified patterns in sequences of rows. Introduced in 12.1.0.1 Reference: [SQL for pattern matching](https://docs.oracle.com/en/database/oracle/oracle-database/23/dwhsg/sql-pattern-matching-data-warehouses.html#GUID-136DAC89-DA17-45C6-9E37-C9892723AC79) as documented in the Data Warehousing Guide
The MATCH_RECOGNIZE clause enables native SQL queries to match specified patterns in sequences of rows.
Introduced in 12.1.0.1
Reference: SQL for pattern matching as documented in the Data Warehousing Guide