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…

Happy Holidays and Cameos Video – Vol 5

I probably won’t put out another post until the new year, so I’ll take this opportunity to wish everyone a happy holiday period, and I hope things will get better for everyone next year!

You may know I have a YouTube channel, and I include cameos of people saying “dot com” at the start of every video. Every now and then I put out a compilation of those clips, and here is volume 5, made up of the clips I used over this this last year.

Thanks to everyone who got involved. These clips are my favourite bit of the videos. 🙂

Stay safe, and see you next year!

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 : Oracle Database 21c Express Edition (XE) Installation

In today’s video we’ll demonstrate how to install Oracle Express Edition 21c on Oracle Linux 8.

The video is based on this article.

Here are some other things you might find useful.

The star of today’s video is Martin Widlake, doing his best Monty Python impression.

Cheers

Tim…

Video : Capture Privilege Usage (DBMS_PRIVILEGE_CAPTURE)

In today’s video we’ll demonstrate the capture privilege usage functionality,
introduced in Oracle 12.1.

The video is based on this article.

The star of today’s video is Maris Elsins, filmed at a UKOUG event a few years ago.

Cheers

Tim…

Video : DML Error Logging

In today’s video we demonstrate DML Error Logging, introduced in Oracle 10.2.

The video is based on a section of this article.

The star of today’s video is Oren Nakdimon, who’s chilling in his garden along with the birds. 🙂

Connor McDonald has done some videos on this feature, which are worth checking out.

Cheers

Tim…