Oracle related rants (and lots of off-topic stuff)…
In today’s video we demonstrate how to format query results in SQLcl using query comments and the SQLFORMAT setting.
For those of you that prefer to read, the video is based on this article.
The star of today’s video is Charles Wilson, who I got chatting with at the OTN lounge at a previous OpenWorld. 🙂
Cheers
Tim…
Today’s video demonstrates how to expand SQL references to views using the DBMS_UTILITY.EXPAND_SQL_TEXT procedure. This functionality was introduced in Oracle 12.1.
The video was based on this article.
The stars of today’s video are Sanjay Kumar, Baljeet Bhasin and Jagjeet Singh, who I met and chatted to at a previous OpenWorld. 🙂
Cheers
Tim…
Today’s video demonstrates the online conversion of a non-partitioned table to a partitioned table. This functionality was introduced in Oracle 12.2.
The examples in the video are taken from this article.
I actually did some rewrites of the article in the process. I noticed a couple of things in it were “less than ideal”. 🙂
The star of today’s video is Roland Smart, who was formerly the VP of Social and Community Marketing at Oracle, which meant he was the boss of the ACE program at the time. He’s since moved on to other marketing-related stuff…
Cheers
Tim…
In today’s video we demonstrate the invisible columns feature introduced in Oracle 12.1.
The video is run through of the examples in this article.
The star of today’s video is John O’Keeffe from More4apps. I first bumped into John many years ago at a conference in Australia, and since then I’ve seen him at a number of events around the world. 🙂
Cheers
Tim…
In today’s video we demonstrate how to move, or rebuild, a table as an online operation.
This video was done as a response to some questions about the previous video on shrink operations. As usual, the video is based on some stuff I’ve written previously.
The star of today’s video is John Kelly.
Cheers
Tim…
In today’s video we’ll give a demonstration of how to shrink tables that contain a lot of free space. As I say in the video, this is not something you should do regularly. It’s only necessary if you’ve done some drastic one-off maintenance, like a large data purge maybe.
There are a few articles this relates to.
The star of today’s video is Kellyn Pot’Vin-Gorman, who is returning to her Oracle roots, but on Azure. 🙂
Cheers
Tim…
Today’s video demonstrates how to configure Kata Containers on Oracle Linux 7 (OL7), allowing you to run containers inside lightweight virtual machines (VMs).
This video is is based on an article of the same name, but relates to a bunch of other articles and videos on the subject of containers.
The star of today’s video is Jake Kuramoto, originally of The AppsLab fame, and now at WorkDay.
Cheers
Tim…
Today’s video is a demonstration of returning REF CURSORs from PL/SQL using functions, procedures and implicit statement results.
I was motivated to do this after a conversation with my boss. He’s from a .NET and SQL Server background, and was a bit miffed about not being able to use a SELECT to pass out variable values from a procedure, like you can in T-SQL. So I piped up and said you can using Implicit Statement Results and another myth was busted. I guess most PL/SQL developers don’t use this, and I don’t either, but you should know it exists so you can be a smart arse when situations like this come up. 🙂
The video is based on these articles.
The star of today’s video is Bryn Llewellyn of PL/SQL fame, and more recently Yugabyte.
Cheers
Tim…
In today‘s video we’ll give a quick demonstration of applying changes to the database using the Liquibase implementation in SQLcl.
The video is based on this article.
You might also find these useful. The secure external password store is a good way to make connections with SQLcl. If you support a variety of database engines, you may prefer to use the regular Liquibase client.
The star of today’s video is Steve Karam from Delphix. 🙂
Cheers
Tim…
Today’s video demonstrates how to use a Secure External Password Store to hold database credentials in a client wallet.
The video is based on this old article.
The star of today’s video is John King. This is actually his second staring role on the channel. The other one was called Making Dreams Come True: Video for a Superfan. 🙂
Cheers
Tim…