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 if Martin Klier. ๐Ÿ™‚

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. ๐Ÿ™‚

 

Video : CASE Expressions and CASE Statements

Today’s video is about CASE expressions and CASE statements.

The guest in today’s video is Scott Wesley, who is currently plugging his new book called Pro jQuery in Oracle Application Express. He will no doubt use the vast quantities of money he makes from the books sales to throw outlandishly extravagant barbecues, because that’s all they do down under. ๐Ÿ™‚

Cheers

Tim…

Video : Indexing JSON Data in Oracle Database 12c

Following on from last week’s post, today’s video is about indexing JSON data in Oracle Database 12c.

If videos arenโ€™t your thing, you might want to read these articles, which the videos are based on.

The cameo in this video comes courtesy of Bertrand Drouvot, who was a silent extra in the previous video too.ย ๐Ÿ™‚

Cheers

Timโ€ฆ

Video : JSON Support in Oracle Database 12c

Today’s video is a sprint through some of the JSON support in Oracle Database 12c.

If videos aren’t your thing, you might want to read these instead.

The cameo in this video comes courtesy of Yves Colin, who I’ll seeย again in a couple of weeks at the Paris Province Oracle Meetup. A couple of extras (Bertrand Drouvot and Osama Mustafa) wanted to get in on the act too. ๐Ÿ™‚

Cheers

Tim…