Oracle related rants (and lots of off-topic stuff)…
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…
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…
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…
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…
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…
VirtualBox 6.1.32 has been released.
The downloads and changelog are in the usual places.
I’ve installed it on Windows 11 and macOS Big Sur hosts with no dramas. Some time in the next 24 hours I’ll upload updated versions of my Oracle Linux 7 and Oracle Linux 8 vagrant boxes.
Cheers
Tim…
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…
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…
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…
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…