Oracle related rants (and lots of off-topic stuff)…
In today’s video we demonstrate the APEX_ZIP package, which allows us to manage zip files from PL/SQL.
The video is based on this article.
I must admit I hadn’t even noticed this package until Morten Braten mentioned it on Twitter.
The star of today’s video is Patrick Jolliffe, who is now a resident of Portugal.
Cheers
Tim…
In today’s video we demonstrate immutable tables, introduced in the April quarterly patches for Oracle database 19c and 21c
The video is based on this article.
You’ll notice a striking resemblance to the syntax of blockchain tables, because they are essentially blockchain tables without the rows chained using cryptographic hashes. You can check out blockchain tables here.
The star of today’s video is Connor McDonald of AskTom and 90-slides-per-minute fame. You can check out Connor’s YouTube channel here.
Cheers
Tim…
In today’s video we’ll demonstrate how to compress and uncompress data from PL/SQL.
The video is based on this article.
The star of today’s video is Chris Saxon of AskTom fame. You can check out his YouTube channel here.
Cheers
Tim…
In today’s video we demonstrate how to rename objects in the Oracle database.
The video is based on these articles.
There is a brief mention of this too.
The star of today’s video is Jeff Smith of SQL Developer, SQLcl and ORDS fame. He’s clearly under some delusion that he’s a terminator… 🙂
Cheers
Tim…
In today’s video we discuss a simple, but significant change introduced in Oracle database 18c.
The video is based on this post.
The star of today’s video is a rather giggly Joel Pérez. We did more takes for this clip than you can imagine, and I still ended up using one of the first. 🙂
Cheers
Tim…
In today’s video we demonstrate attribute clustering, introduced on Oracle database 12.1.
The video is based on this article.
The star of today’s video is Francesco Tisiot, who seems to have some aversion to putting pineapple on pizza. Why anyone would ask an Italian about pizza is beyond me… 🙂
Cheers
Tim…
In today’s video we demonstrate the CREATE TABLE … FOR EXCHANGE WITH TABLE feature, introduced in Oracle database 12.2.
The video is based on this article.
You can check out my other partitioning articles here.
The star of today’s video is Frits Hoogland and his son. This clip is from six years ago, and I don’t think Frits look any different today, but I’m guessing his son has changed a lot in that time. 🙂 Frits recently set sail for the land of Yugabyte. I hope he will come back to visit from time to time… 🙂
Cheers
Tim…
In today’s video we demonstrate blockchain tables, introduced in Oracle database 21c.
The video is based on this article.
As I mention in the video and the article, blockchain tables are a niche feature, but it’s good to know they exist in case you come across a requirement where they would be useful.
The star of today’s video is Martin Klier. 🙂
Cheers
Tim…
In today’s video we demonstrate some more of the enhancements to qualified expressions in Oracle database 21c.
You can see the first part here. This is the second video based on this article.
If you are new to qualified expressions, and don’t already know about the FOR LOOP enhancements in 21c, these may be helpful.
The star of today’s video is Kim Berg Hansen, who is an Oracle ACE Director and long time SQL and PL/SQL developer and advocate.
Cheers
Tim…
In today’s video we demonstrate some of the enhancements to qualified expressions in Oracle database 21c.
The video is based on this article.
If you are new to qualified expressions, and don’t already know about the FOR LOOP enhancements in 21c, these may be helpful.
The star of today’s video is Mike Hichwa. Everything you know and love about APEX started with this guy!
Cheers
Tim…