SQL and PL/SQL Enhancements

From Robs_Wiki
Jump to: navigation, search

DML 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.

DDL Enhancements

PL/SQL Enhancements