SQL and PL/SQL Enhancements

From Robs_Wiki
Revision as of 08:26, 14 February 2020 by Qadmin wiki (talk | contribs) (Created page with "__TOC__ == DML Enhancements == === Row Pattern Matching === Pattern matching provides the ability to recognize patterns in a sequence of rows in a projection, called the row...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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