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…

Video : Qualified Expressions Enhancements in Oracle Database 21c (part 1)

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…

Video : FOR LOOP Iteration Enhancements in Oracle Database 21c

In today’s video we demonstrate the FOR LOOP iteration control enhancements in Oracle database 21c.

The video is based on this article.

If you’re not already got up to speed with qualified expressions in 18c, you might want to check this out also.

The star of today’s video is Alex Nuijten, of PL/SQL and in recent years APEX fame.

Cheers

Tim…

Video : Using Expressions in Initialization Parameters in Oracle Database 21c

In today’s video we demonstrate using expressions in initialization parameters, introduced in Oracle database 21c.

The video is based on this article.

The star of today’s video is Deiby Gรณmez, who is a fellow Oracle ACE Director, and was kind enough to take me sightseeing when I visited Guatemala for a conference.

Cheers

Tim…

Video : Partial Indexes for Partitioned Tables

In today’s video we demonstrate partial indexes for partitioned tables, introduced in Oracle database 12.1.

The video is based on this article.

The star of today’s video is Carry Millsap, who is being lead astray by a very naughty James Morle.

Cheers

Tim…

Video : JSON_TRANSFORM in Oracle Database 21c

In today’s video we demonstrate the JSON_TRANSFORM function, introduced in Oracle database 21c.

This video is based on the following article, which has a lot more information and examples than the video does.

I’ve written a bunch of stuff on JSON and ORDS, and there’s a YouTube playlist.

The star of today’s video is Tom Kyte. Here are two funny (to me) stories about my interactions with Tom.

On my first visit to OpenWorld in 2006, Tom walked up to me and introduced himself. I was blown away he even knew who I was. It was a massive ego trip. On my next visit to OpenWorld in 2007, I walked up to Tom and said casually, “Hi Tom”. He looked at me, looked down at my conference badge, looked at me again and said, “Hi Tim”. Needless to say, my ego was placed firmly back where it belonged. I still laugh when I think about it now.

At a later OpenWorld I was sitting at a table and someone was fanboying me. Tom came along and asked if he could sit at the same table. I said sure. My fanboy turned and said in a rather snarky tone, “And who are you?” Tom replied, “Hi. I’m Tom Kyte”. Fanboy’s face immediately dropped and at that exact moment in time I became invisible, and fanboy began to fanboy Tom. It was priceless!

Good times!

Cheers

Tim…

Video : Long Identifiers in Oracle Database 12.2 Onward

In today’s video we’ll quickly demonstrate long identifiers, introduced in Oracle database 12.2.

The video is based on this article.

I was moved to make this because I saw someone on Twitter complaining about the 30 character limit in Oracle. I figured they were probably using an old version of the database, but that’s their fault. A short video was convenient, as I was working this weekend, and didn’t have much free time. ๐Ÿ™‚

The star of today’s video is Marcelle Kaye, in honour of her recent birthday. Hopefully we will get to meet up again one day…

Cheers

Tim…