In today’s video we demonstrate the DDL_LOCK_TIMEOUT feature, introduced in 11g.
The video is based on this article.
The star of today’s video is Bertrand Drouvot, who’s sporting a particularly impressive beard here. 🙂
Cheers
Tim…
Category: Video
Video : TRUCATE TABLE … CASCADE
In today’s video we demonstrate the TRUNCATE TABLE … CASCADE feature added in Oracle 12.1.
The video is based on this article.
The star of today’s video is Øyvind Isene, who reluctantly took a break from his coffee to let me film this clip. 🙂
Cheers
Tim…
Video : APEX_MAIL : Send Emails from PL/SQL
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.
- Email From Oracle PL/SQL (UTL_SMTP)
- UTL_MAIL : Email from PL/SQL in the Oracle Database
- Fine-Grained Access to Network Services Enhancements in Oracle Database 12c Release 1
- Configure Postfix as an Email Relay on Oracle Linux Servers
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…
Video : APEX_ZIP : Manage Zip Files From PL/SQL
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…
Video : Immutable Tables in Oracle Database 19c and 21c
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…
Video : Rename Objects (Tables, Columns, Constraints, Indexes, Tablespaces) in Oracle Database
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.
- Online Move Datafile in Oracle Database 12c Release 1 (12.1)
- Multitenant : Online Move of Datafiles in CDBs and PDBs (Video)
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…
Video : DBMS_SESSION.SLEEP Replaces DBMS_LOCK.SLEEP in Oracle Database 18c
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…
Video : Attribute Clustering in Oracle Database 12c Onward
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…
Video : Create Table for Exchange With a Partitioned Table
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…
Video : Qualified Expressions Enhancements in Oracle Database 21c (part 2)
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.
- Qualified Expressions (Populating Record Types and Associative Arrays) in PL/SQL in Oracle Database 18c
- FOR LOOP Iteration Enhancements in Oracle Database 21c
- FOR LOOP Iteration Enhancements in Oracle Database 21c (Video)
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…