Video : Analytic Function Exclude Clause in Oracle Database 21c

In today’s video we’ll demonstrate the analytic function exclude clause, introduced in Oracle database 21c.

The video is based on the following article.

You might also find these useful.

The star of today’s video is Rene Antunez, who took a few of us to see the Pyramids of Teotihuacan when we were in Mexico on an ACE speaker tour.

Cheers

Tim…

Video : Analytic Functions Groups Clause in Oracle Database 21c

In today’s video we’ll demonstrate the analytic functions groups clause, introduced in Oracle database 21c.

The video is based on the following article.

You might also find these useful.

The star of today’s video is a certain well known virus, knitted by the wife (Debra Lilley). This is what social isolation has done to her. 🙂

Cheers

Tim…

Video : Analytic Function Window Clause in Oracle Database 21c

In today’s video we’ll demonstrate the analytic functions window clause, introduced in Oracle database 21c.

The video is based on the following article.

You might also find these useful.

The star of today’s video is Peter Scott, who took time out of his life of luxury in France to say “.com” for this video. 🙂

Cheers

Tim…

Video : NTH_VALUE : Problem Solving using Analytic Functions

Today’s video is a demonstration of the NTH_VALUE analytic function.

This is based on this article.

You might find these useful also.

The star of today’s video is Connor McDonald. This is his second visit to the channel. I’m sure most of you must know Connor from his blog and AskTom. He also has a YouTube channel here.

Cheers

Tim…

Video : LISTAGG Analytic Function in Oracle Database

Today’s video is a run through the LISTAGG analytic function, with a little included 19c goodness.

If video is not your thing, you can get all the relevant information from these articles.

The star of today’s video is Michael Rainey. 🙂

Cheers

Tim…