SQL and PL/SQL Enhancements
Row Pattern Matching
Pattern matching provides the ability to recognize patterns in a sequence of rows in a projection, called the row pattern input table. Note that this kind of pattern matching is different from that which occurs with matching clauses such as the like clause. The like clause looks for a pattern match within a single column of a single row. In this case we are looking for pattern matches in a set of rows.