Video : DDL_LOCK_TIMEOUT : DDL With the WAIT Option

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…

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.

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.

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.

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…