Video : RANK and DENSE_RANK Aggregate Functions : Making Ranking Predictions

In today’s video we demonstrate the RANK and DENSE_RANK aggregate functions, using them to make ranking predictions.

The video is based on part of this analytic functions article.

RANK and DENSE_RANK Analytic Functions

You might find these useful.

The star of today’s video is Kim Berg Hansen, who is an all round SQL and PL/SQL good guy, as well as a tireless contributor to the Dev Gym.

Cheers

Tim…

Video : SecureFiles Shrink in Oracle Database 21c

In today’s video we’ll demonstrate the SecureFiles Shrink feature, introduced in Oracle database 21c.

The video is based on this article.

You might also find these useful.

The star of today’s video is Arman Sharma. This clip was from Sangam15. To think that was seven years ago is mind-blowing!

Cheers

Tim…

Video : EXCEPT and EXCEPT ALL Set Operators in Oracle Database 21c

In today’s video we demonstrate the EXCEPT and EXCEPT ALL set operators, introduced in Oracle database 21c.

The video is based on this article.

You might also find these useful.

The star of today’s video is Chris Saxon, who you’ll know from AskTom and his YouTube channel.

Cheers

Tim…

Video : INTERSECT ALL Set Operator in Oracle Database 21c

In today’s video we demonstrate the INTERSECT ALL set operator, introduced in Oracle database 21c.

The video is based on this article.

You might also find these useful.

The star of today’s video is Francesco Tisiot, who for some reason is incapable of understand the virtues of putting pineapple on pizza, or snapping spaghetti in half so it fits in the pan!

Cheers

Tim…

Video : MINUS ALL Set Operator in Oracle Database 21c

In today’s video we’ll demonstrate the MINUS ALL set operator,
introduced in Oracle database 21c.

The video is based on this article.

You might also find these useful.

The star of today’s video is Ludovico Caldara, who looks a little different than I remember him.

Cheers

Tim…

Video : ANY_VALUE Aggregate Function in Oracle Database 21c

In today’s video we’ll demonstrate the ANY_VALUE aggregate function, introduced in Oracle database 21c.

The video is based on this article.

The star of today’s video is Scott Spendolini, who I suspect has used APEX at least once or twice in his life…

Cheers

Tim…

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 : Multivalue Function-Based Indexes for JSON_EXISTS in Oracle Database 21c

In today’s video we demonstrate multivalue function-based indexes for JSON_EXISTS, introduced in Oracle 21c.

The video is based on this article.

You may also find these helpful.

The star of today’s video is my sister-in-law and the queen of the database Maria Colgan. It’s a pleasure to be one of your unworthy minions… 🙂

Cheers

Tim…