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 : Attention Log in Oracle Database 21c

In today’s video we discuss the attention log, introduced in Oracle database 21c.

The video is based on this article.

You might also find this useful.

The star of today’s video is Zahid Anwar, who despite being a fellow Brit, is filmed here in the USA. It’s funny how things work out. 🙂

Cheers

Tim…

Video : DBMS_XPLAN : Compare Execution Plans in Oracle Database 19c and 21c

In today’s video we’ll demonstrate the compare plans routines, added to the DBMS_XPLAN package in Oracle database 19c and 21c.

The video is based on the following article.

The star of today’s video Lumpy the donkey, who is being held by Bjoern Rost.

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…

ORDS, SQLcl, SQL Developer and SQL Data Modeler New Releases (21.4.x)

We’ve got some early Christmas presents!

I’ve updated my Docker and Vagrant builds to use the new versions of ORDS and SQLcl. You can see them here.

You can read Jeff Smith‘s announcement posts here, which include an overview of some of the new features.

Only the SQL Developer and Data Modeler releases were as a result the Log4j issue. They are client tools, so they are not really a threat, but it’s good to get the updates through so fast.

You have permission to open your presents early! 😁

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…