Video : JSON_OBJECT Function Enhancements in Oracle Database 19c

Today’s video is a demonstration of some of the enhancements to the JSON_OBJECT function in Oracle Database 19c.

If videos aren’t your thing, you can get the same information, and more, from this article.

The star of today’s video is Patrick Jolliffe. πŸ™‚

Cheers

Tim…

Video : SQL/JSON : Generate JSON from SQL

Today’s video is a quick run through some of the SQL/JSON functionality introduced in Oracle database 12.2.

For those people that want a lot more information, including copy/paste examples, check out the article it’s based upon, and all the other JSON stuff I’ve written here.

The star of today’s video is Roel Hartman of APEX fame!

Cheers

Tim…

Video : Override External Table Parameters and Inline External Tables in Oracle Database

Today’s video gives a quick demonstration of overriding external table parameters and inline external tables introduced in Oracle database 12.2 and 18c respectively.

There is a more general video on external tables here.

For those of you that don’t do YouTube, you can read all the articles here.

The cameo on this video is Ilmar Kerm, in a really noisy bar. πŸ™‚

Cheers

Tim…

Video : Real-Time Materialized Views

Today’s video is a quick demo of Real-Time Materialized Views,
introduced in Oracle Database 12c Release 2 (12.2).

This is based on information from the following articles.

The cameo for today’s video is Maria Colgan. πŸ™‚

Cheers

Tim…

Video : Collation and Case-Insensitive Queries in Oracle Database

Today’s video is a run through the Collation functionality introduced in Oracle Database 12c Release 2 (12.2).

If videos aren’t your thing, you can find a lot more information about this subject in my article here.

The cameo in today’s video is Kim Berg Hansen. πŸ™‚

Cheers

Tim…

PS. Subscribe to my YouTube channel here.

Video : Extended Data Types in Oracle Database 12c Onward

Today’s video is a quick run through the Extended Data Types functionality introduced in Oracle Database 12c Release 1. Why such an old subject? Well, it’s a prerequisite for something I was planning to do a video on, so I thought I better do this first. πŸ™‚

For those that don’t like videos, you can find the same information and more here.

The cameo in today’s video is Martin Klier. πŸ™‚

Cheers

Tim…

PS. Subscribe to my YouTube channel here.

Video : JSON Data Guide

Today’s video is an overview of the JSON Data Guide functionality introduced in Oracle 12.2.

If videos aren’t your thing, you can read the articles instead. This video focuses on the main features that were introduced in 12.2, but there are some nice additions in 18c also.

The cameo in today’s video is Toon Koppelaars of #SMartDB fame.

Cheers

Tim…

PS. Subscribe to my YouTube channel here.

Video : Table Point In Time Recovery (PITR) in Oracle Database 12c

It’s been a while, but here is a the latest video.

If videos aren’t your thing, you can read the articles here.

The star of this video is Uwe Hesse, who I recorded at UKOUG Tech 15. Yes, I did mean “15”. I have a bit of a backlog to work through. πŸ™‚

Cheers

Tim…

PS. Subscribe to my YouTube channel here.

Video : Oracle Data Guard Broker

Today’s video is a quick demonstration of the Oracle Data Guard Broker.

Having recently written an article on it (here), I though a quick run through might help people see how easy it is. Maybe they will get converted like me. πŸ™‚

The star of this video is Liron Amitzi, whose shopping habits have probably boosted the Canadian economy since his move there. By now I expect all the shelves in all the shops in Vancouver have been emptied. πŸ™‚

Cheers

Tim…

PS. I know I keptΒ exiting to reconnect when I could have used CONNECT. I told you I’m new to this broker stuff. πŸ™‚