Video : ANY_VALUE Aggregate Function in Oracle Database 21c

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

The video is based on this article.

The star of today’s video is Scott Spendolini, who I suspect has used APEX at least once or twice in his life…

Cheers

Tim…

Video : Analytic Function Exclude Clause in Oracle Database 21c

In today’s video we’ll demonstrate the analytic function exclude clause, introduced in Oracle database 21c.

The video is based on the following article.

You might also find these useful.

The star of today’s video is Rene Antunez, who took a few of us to see the Pyramids of Teotihuacan when we were in Mexico on an ACE speaker tour.

Cheers

Tim…

ORDS, SQLcl, SQL Developer and SQL Data Modeler New Releases (21.4.x)

We’ve got some early Christmas presents!

I’ve updated my Docker and Vagrant builds to use the new versions of ORDS and SQLcl. You can see them here.

You can read Jeff Smith‘s announcement posts here, which include an overview of some of the new features.

Only the SQL Developer and Data Modeler releases were as a result the Log4j issue. They are client tools, so they are not really a threat, but it’s good to get the updates through so fast.

You have permission to open your presents early! 😁

Cheers

Tim…

Video : Analytic Functions Groups Clause in Oracle Database 21c

In today’s video we’ll demonstrate the analytic functions groups clause, introduced in Oracle database 21c.

The video is based on the following article.

You might also find these useful.

The star of today’s video is a certain well known virus, knitted by the wife (Debra Lilley). This is what social isolation has done to her. 🙂

Cheers

Tim…

Video : Analytic Function Window Clause in Oracle Database 21c

In today’s video we’ll demonstrate the analytic functions window clause, introduced in Oracle database 21c.

The video is based on the following article.

You might also find these useful.

The star of today’s video is Peter Scott, who took time out of his life of luxury in France to say “.com” for this video. 🙂

Cheers

Tim…

Video : Gradual Database Password Rollover Time

In today’s video we demonstrate gradual database password rollover time, introduced in Oracle database 21c, and backported to 19c.

The video is based on this article.

This is a small, but really useful quality of life feature!

The stars of today’s video are the offspring of Jeff Smith. It was cold, dark and miserable when I recorded the video, and this is one of my favourite clips, so I included it to bring a touch a summer! 🙂

Cheers

Tim…

Video : Oracle Data Pump 21c and Cloud Object Stores

In today’s video we’ll use Oracle Data Pump 21c to export to, and import from, a cloud object store.

The video is based on this article.

You might find the following articles useful as part of the setup.

The star of today’s video is Markus Michalewicz, the Vice President of Product Management; Database High Availability, Scalability, MAA & Cloud Migration at Oracle. That’s a bit of a mouthful. 🙂

Cheers

Tim…

APEX 21.2 : Vagrant and Docker Builds

Unless you live under a rock, you’ll have seen APEX 21.2 was released yesterday. Being the worlds worst APEX developer, I’m not going to speak about the new release, as I’ll just embarrass myself, but I did want to give a heads-up of what I’ve been doing since the release.

Vagrant Builds

A number of my Vagrant database builds include APEX. Those that do have been updated to use APEX 21.2. You can find them here.

They had already been updated to use the latest versions of Java, Tomcat, ORDS and SQLcl where appropriate, so the APEX upgrade was a small change.

You can read my beginner’s guide to Vagrant here.

Docker/Container Builds

I have some ORDS containers that include the APEX images, so those image builds have been updated to use the APEX 21.2 images now. You can find them here.

As with the Vagrant builds, these had already been updated to use the latest versions of Java, Tomcat, ORDS and SQLcl where appropriate.

You can read my Docker/Container articles here.

Thoughts

It’s taken a long time for us to roll out APEX 21.1 at work. Most of that delay is because of competing priorities. We’ve been pushing the Oracle 19c database upgrades hard, and it’s not left much space to focus on APEX. The last of our production systems will be upgraded to APEX 21.1 next week, so I’m not sure how eager people will be when I start pushing 21.2. 🙂 I’ll try, but it might have to wait until next quarter’s security patching. We’ll see.

Despite that, APEX 21.1 is now dead to me. Long live APEX 21.2. 🙂

Cheers

Tim…