The ability to find and analyze the patterns in the data was widely desired but not possible with SQL until Oracle 12c.
This is required in many business areas, for example, security applications and fraud detection or financial applications and pricing analysis. Native pattern-matching capabilities in SQL help to avoid complex bespoke solutions on the client side or within the middle-tier application server and use easy-to-share SQL queries instead.
This is the last one of Oracle’s specific SQL features, but before diving into it, let’s briefly recall the evolution of SQL.
Basic ...
