Video : SQLCL and Liquibase : Deploying Oracle Application Express (APEX) Applications

In today’s video we’ll give a quick demonstration of deploying an APEX application using the SQLcl implementation of Liquibase.

I Know what you’re thinking. Didn’t I do this video two weeks ago? The answer is yes and no. This video is very similar to the Liquibase video I did two weeks ago, but that was using the Liquibase Pro client. This video uses the SQLcl implementation of Liquibase, and more specifically the runOracleScript tag to achieve the same thing.

The video is based on this article, which has an example of deploying an APEX workspace and an APEX application.

If you are new to Liquibase and SQLcl, you might find it easier to start with these.

The stars of today’s video are the offspring of Jeff Smith. I had been annoying Jeff on Twitter DMs while he was meant to be on holiday, so I agreed to pay him back by turning his children into international megastars. I take no responsibility for how they handle the fame! 😉

Cheers

Tim…

20 Years of ORACLE-BASE.com

It was twenty years ago today that the first incarnation of my website was born.

It started life as a few scripts and notes put on the internet so I didn’t have to carry them around on floppy disks or CDs when I was moving around between contracts. I had been working with Oracle technologies for five years before the website was born, but most of the early content was Oracle 8i stuff.

I added new articles now and then, but I guess it really started to take off when I was preparing for the Oracle 9i OCP upgrade exam. For the 7.3, 8 and 8i OCP exams I used books to prepare, but for 9i OCP I decided to do the beta exam. This meant there were no books available yet, so I had to do it the hard way. I wrote my own revision notes for the whole of the syllabus and put them on the website. They got pretty popular, as free things often do. 🙂 From that point on I just kept adding articles on a regular basis.

Over the last 20 years the site has gone through lots of changes, but also stayed reassuringly the same. It takes a lot of work to keep producing new articles, but what most people don’t see is the amount of time that is taken up reworking some of the old articles. Some of this stuff was written 20 years ago and I come back to things and want to hang my head in shame. Someone will ask a question about an article, I will read it, hate it and rework it. It’s a never ending job, and the more you write, the more you have to refactor down the line. 🙂

Thanks to everyone who has supported me over the last 20 years. It’s not over yet.

Cheers

Tim…

Video : Hybrid Partitioned Tables in Oracle Database 19c

In today’s video we’ll give a quick demonstration of Hybrid Partitioned Tables, introduced in Oracle Database 19c.

The video is based on this 19c article.

The video only has a single example using external partitions pointing to CSV data. The article also includes and example using a Data Pump file.

The star of today’s video is Oren Nakdimon, who was taking a day off from being a God of Edition-Based Redefinition. 🙂

Cheers

Tim…

Video : Liquibase : Deploying Oracle Application Express (APEX) Applications

Today’s video is a quick demonstration of deploying an Oracle Application Express (APEX) application using Liquibase.

The video is based on a new article of the same name, which covers the deployment of both APEX workspaces and APEX applications using Liquibase.

Here’s some other content you might find useful.

The star of today’s video is Jorge Rimblas, making a welcome return to the channel, along with some serious reverb. 🙂 Last time we saw Jorge was in a boxing gym, and his daughters have also taken the spotlight for one video.

Cheers

Tim…

Video : APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data to rows and columns

Today’s video is a quick demonstration of using the APEX_DATA_PARSER package to convert simple CSV, JSON, XML and XLSX data into rows and columns.

If you want the copy/paste examples and the test files, you can get them from this article.

Yet another reason why you should always install APEX in your databases.

The star of today’s video is Kosseila.HD, also known as BrokeDBA, complete with sun glasses, basket ball and a rattling watch. 🙂

Cheers

Tim…

Video : Podman : Generate and Play Kubernetes YAML Files

Today’s video demonstrates Podman’s ability to generate and play Kubernetes YAML files.

This is based on the following article.

You can might want to check out these also.

The star of today’s video is Max McDonald, son of Connor McDonald.

Cheers

Tim…

Do you want to be a star?

If you’ve followed my YouTube channel, you’ll know I include a clip of people from the community saying “.com” at the start of each video. It’s just a silly tradition, and it allows me to give a shout out to other people.

When I started the channel I used to record loads of these at conferences, but I acquired so many I stopped doing it, until I could get through what I already had. I have now used all of them…

If you would like to star in a video, please do the following:

  • Drop me an email with your video clip saying “.com”. You know my name is “tim” and my website is “oracle-base.com”, so you can guess my email address.
  • Please say “.com” 2 or 3 times with a 1 second gap between them.
  • In the email give me your name and social media links, so I can include them in the video description and associated blog post. I am terrible with names, even people I’ve met a lot, so don’t count on me remembering your name. 🙂
  • Landscape videos are better, but portrait are OK.

I’m happy to receive repeat appearances of people who have done a clip before, so don’t be shy.

You can see some of the previous stars in the compilation videos on this playlist.

Cheers

Tim…

PS. I think it’s only fair to warn you, this will not make you a star… 🙂

Video : Using Podman With Existing Dockerfiles (Oracle Database and ORDS)

Today’s video shows me using some of my existing Docker builds with Podman. Specifically a 19c database container and an Oracle REST Data Services (ORDS) container.

For those with an understanding of Docker, it should look really familiar, but it does introduce a twist in the form of a pod.

The video is based on this article.

You can see more information about containers here.

The star of today’s video is Bart Sjerps. It was really hard to find a piece of this recording that didn’t have James Morle wittering over everyone on it. 🙂

Cheers

Tim…

8 years and counting…

I just noticed today is the 8 year anniversary of working for my current company.

I wrote a blog post about the interview before I got the job (here).

About 3 months after I started the job I wrote an update post, and clearly wasn’t too happy with the way things were going (here).

There was a rather unenthusiastic post about my four year anniversary (here).

Now here I am after eight years and I’m still having the same arguments about my role on an almost daily basis. It’s like a bad relationship I can’t break free from. Some sort of He Hit Me (And It Felt Like A Kiss) kind-of thing.

Let’s see what this next year brings…

Cheers

Tim…

PS. At least now I’m working from home, which is better.

PPS. Thanks to the people who contacted me out of concern. This is not a cry for help. 🙂 You really don’t need to worry about me. Every job has pros and cons. This job has lots of cons, but there are some pros too. At the moment the pros still outweigh the cons (just about). If that changes, I’ll take a few years off work again. This is not drama. Just how I feel…