Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. There were many workarounds, but these were difficult to write, hard to understand, and inefficient to execute. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL to do the following:
Please Log In to Bookmark this Video
Be the first to review this content item!
Release Date: 12-NOV-2013
Click for details
Information about Related Products
Welcome! Would you like to set up your user profile? We can provide you with content recommendations based on your preferences.