This tutorial provides an introduction to the Structured Query Language (SQL), learn how to create t...

Define blocks of procedural of code using PL/SQL.

An introduction to using subqueries in Oracle Database

In this tutorial you will learn how to create an analytic view using data in the AV sample schema. ...

This Tutorial introduces the new JSON-related extensions to SQL and PL/SQL that have been added to O...

An introduction to creating tables and the types of these available in Oracle Database.

Learn how to create database sequences and how they can be referenced from triggers and within PL/SQ...

An introduction to handling null, including three-valued logic and null related functions. Click "Ex...

This tutorial demonstrates different variations of the UPDATE statement. It includes examples of bas...

An introduction to analytic functions.

This is a simple example that introduces the main keywords used in MATCH_RECOGNIZE. During this tuto...

An introduction to how to use pivot & unpivot to convert rows to columns and back.

An introduction to using connect by and recursive with to traverse trees.

This tutorial is part of the Oracle Dev Gym class "Get Started with Table Functions". This module of...

An introduction to sorting data with order by and restricting rows to the top N.

Tutorial introducing new and enhanced Partitioning functionality in Oracle Database 12c Release 2.

This session demonstrates how, using SQL pattern matching techniques, you can speed up searching for...

An introduction to the various data types available in Oracle Database.

An introduction to the join types available in Oracle Database.

An introduction to the set operators, union, minus, and intersect

This tutorial provides an introduction to querying hierarchies and analytic views. This is a good s...

An introduction to how to summarise data using aggregate functions and group by.

An introduction to how to use merge to do insert-or-update logic.

This tutorial provides examples for creating time series calculations such as prior periods, year ag...

This tutorial will create an analytic view and supporting objects using data in the Sales History (S...

An introduction to designing database tables.

An introduction to adding rows to tables with insert. And saving or undoing these changes with commi...

An introduction to returning data from tables with select and filtering the results using where. ...

Hands-On-Lab for ODTUG Kscope17 in San Antanio. The modules give examples of analytic functions i...

This tutorial shows how to use materialized views to accelerate queries that select from analytic vi...

The enhanced CAST function (along with TO_NUMBER, TO_BINARY_FLOAT, TO_BINARY_DOUBLE, TO_DATE, TO_TI...

This tutorial is part of the Oracle Dev Gym class "Get Started with Table Functions". Pipelined tabl...

This tutorial provides examples of adding multiple language support to analytic views.

This tutorial is part of the Oracle Dev Gym class "Get Started with Table Functions". This module sh...

An introduction to the read consistency model in Oracle Database

This is a simple demo showing how to use SQL pattern matching for fraud analysis. It is part of a pr...

Approximate Query Processing provides approximate result capabilities in SQL. The motivation behind ...

An introduction to how to change row values with update. Also an overview of how to manage transacti...

How to use new 12c SQL pattern matching match_recognize feature for sessionization analysis on web l...

The tutorial will help explain the new 12.2 syntax for LISTAGG which provides developers with additi...

The aim of this tutorial is to explain the importance of using PARTITION BY and ORDER BY to ensure t...

Hands-On-Lab for ODTUG Kscope17 in San Antanio. The modules give examples of row pattern matching...

In this tutorial we will review the two built-in measures that are part of MATCH_RECOGNIZE. These me...

An introduction to how to remove rows from a table using delete and truncate.

How to use new 12c SQL pattern matching match_recognize feature for sessionization analysis based on...

This tutorial is part of the Oracle Dev Gym class "Get Started with Table Functions". This module sh...

Oracle XML DB is a set of Oracle Database technologies related to high-performance handling of XML d...

The aim of this tutorial is to explain the difference between the various row output options within ...

Weighted averages are often needed to correctly aggregate average in aggregate levels of a hierarchy...

This tutorial is linked to one of my blog posts"Managing overflows in LISTAGG" - https://oracle-big-...

We use the AFTER MATCH SKIP clause to determine the precise point to resume row pattern matching aft...

SHARE_OF expressions calculate the ratio of a hierarchy value to the value of a parent or an ancesto...

In this tutorial we will review the concepts of greedy and reluctant quantifiers. Pattern quantifier...

This tutorial will help you understand why you might get errors such as ORA-904 "%s: invalid identif...

When SELECTing data from an analytic view the FILTER FACT keywords can be used to filter data prior ...