This demonstration compares the use of parallel and serial processing for the same SQL query. This demonstration is associated with lessons 2 and 3 of the Oracle University seminar: Parallel Processing in Oracle 11g.
The new groundbreaking SQL pattern matching capabilities brings the simplicity and efficiency of the most common data analysis language to the process of identifying patterns within a data set. It provides a completely new native SQL syntax that has adopted the regular expression capabilities of Perl by implementing a core set of rules to define patterns in sequences (streams of rows). In this first session will explore some of the main concepts and key words of the new syntax. Subsequent sessions will explore typical use cases for SQL pattern matching and how to debug your pattern matching process.
Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information:
There are several features in Oracle Database 12c Release 1 of which you can take advantage
when it comes to Data Warehousing and Business Intelligence (BI).
In this podcast we review some of the key concepts around the way data sets are processed by SQL analytics
In this podcast we review the extensions to the SQL GROUP BY clause, which allow developers and business users to add subtotals and grand-totals to their result sets. These can range from simple row/column subtotals to the creation of sophisticated hierarchical, multi-dimensional cubes.
In this podcast we explore some examples of how to use SQL analytics to answer some typical business questions.
In an earlier podcast we introduced the concepts of windows in this podcast we are going to look a little deeper at how analytical windows work.
In this podcast we review some of the optimizations included in the database to support the SQL analytics
In this simple demo we explore how to calculate the average 90 day stock balance using SQL analytics.
In this podcast we continue our review some of the key concepts around the way data sets are processed by SQL analytics
This podcast is the first in a series of podcasts that will look at the core concepts behind Oracle’s in-database SQL analytics and examine, in detail, some of the key features and functions.
Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improve application and development productivity and query efficiency for row-sequence analysis.Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. With Oracle Database 12c Release 1 (12.1), you can use the MATCH_RECOGNIZE clause to perform pattern matching in SQL.
Oracle Product Manager, Keith Laker, demonstrates how to work with SQL Pattern Matching in Oracle Database 12c in this second of three demos. See Keith's blog for more information.
Oracle Product Manager, Keith Laker, demonstrates how to work with SQL Pattern Matching in Oracle Database 12c in this three-part video series. See Keith's blog for more information.