video

Today’s video gives a demonstration of Online Statistics Gathering for Bulk Loads.

This is based on this article.

In today’s video we give a quick demonstration of using catcon.pl to run scripts against multiple pluggable databases (PDBs) in a container database (CDB).

The video is based on one section of this article.

• Multitenant : Running Scripts Against Container Databases (CDBs) and Pluggable Databases (PDBs) in Oracle Database 12c Release 1 (12.1)

You can find loads of information about living with CDBs and PDBs in the following articles and the YouTube playlist linked below.

In today’s video we’ll give a quick demonstration of using the APEX command-line export utility.

The video is based on this article, which includes more examples, and Windows-based examples also.

• APEXExport : Export APEX Applications and Workspaces From the Command Line

The star of today’s video is my daughter Heli “Hell-Squirel” Helskyaho. Make sure you check out the cloud forming a Pikachu tail above her head!

• APEX
• apexexport
• application
• application express
• export
• Oracle
• video
• workspace

In today’s video we give a quick demonstration of using the SQL Quarantine features of Oracle Database 19c.

It’s a follow-on to last week’s video.

• Resource Manager : Runaway Query Management

Today’s video is a cut down of this article.

• SQL Quarantine in Oracle Database 19c

These might come in handy too.

In today’s video we give a quick demonstration of using Resource Manager to cancel a long running SQL statement.

This video is based on a series of articles from Oracle 8i to the present day. There is an example here.

• Resource Manager : Runaway Query Management

Although there are aspects of it throughout most of the Resource Manager articles on the website.

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.

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.

• Hybrid Partitioned Tables in Oracle Database 19c

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.

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.

• Liquibase : Deploying Oracle Application Express (APEX) Applications

Here’s some other content you might find useful.

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.

• APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data as rows and columns

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

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

This is based on the following article.

• Podman : Generate and Play Kubernetes YAML Files

You can might want to check out these also.