Oracle related rants (and lots of off-topic stuff)…
In today’s video we demonstrate the relationship between the APPEND hint, redo generation and NOLOGGING.
The video is based on a section of this article.
The star of today’s video is Danny Bryant. This clip is from back in his Oracle days, but he’s now moved to the colder climate of Snowflake.
Cheers
Tim…
In today’s video we demonstrate using GRANT CONNECT THROUGH to enable proxy authentication.
The video is based on this article.
The star of today’s video is Lonneke Dikmans, who always seems to be doing something cooler than me. Check out DoeMee, an app that “offers a total model for contemporary governance”.
Cheers
Tim…
In today’s video we’ll demonstrate how to use the APEX_MAIL package to send emails from PL/SQL.
The video is based on this article.
You may also want to check out these articles.
The star of today’s video is Paul Vallee, who knocked it out of the park with his recent post on hybrid working.
Cheers
Tim…
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…