Oracle related rants (and lots of off-topic stuff)…
In today’s video we demonstrate the FOR LOOP iteration control enhancements in Oracle database 21c.
The video is based on this article.
If you’re not already got up to speed with qualified expressions in 18c, you might want to check this out also.
The star of today’s video is Alex Nuijten, of PL/SQL and in recent years APEX fame.
Cheers
Tim…
In today’s video we demonstrate using expressions in initialization parameters, introduced in Oracle database 21c.
The video is based on this article.
The star of today’s video is Deiby Gómez, who is a fellow Oracle ACE Director, and was kind enough to take me sightseeing when I visited Guatemala for a conference.
Cheers
Tim…
In today’s video we demonstrate partial indexes for partitioned tables, introduced in Oracle database 12.1.
The video is based on this article.
The star of today’s video is Carry Millsap, who is being lead astray by a very naughty James Morle.
Cheers
Tim…
In today’s video we demonstrate the JSON_TRANSFORM function, introduced in Oracle database 21c.
This video is based on the following article, which has a lot more information and examples than the video does.
I’ve written a bunch of stuff on JSON and ORDS, and there’s a YouTube playlist.
The star of today’s video is Tom Kyte. Here are two funny (to me) stories about my interactions with Tom.
On my first visit to OpenWorld in 2006, Tom walked up to me and introduced himself. I was blown away he even knew who I was. It was a massive ego trip. On my next visit to OpenWorld in 2007, I walked up to Tom and said casually, “Hi Tom”. He looked at me, looked down at my conference badge, looked at me again and said, “Hi Tim”. Needless to say, my ego was placed firmly back where it belonged. I still laugh when I think about it now.
At a later OpenWorld I was sitting at a table and someone was fanboying me. Tom came along and asked if he could sit at the same table. I said sure. My fanboy turned and said in a rather snarky tone, “And who are you?” Tom replied, “Hi. I’m Tom Kyte”. Fanboy’s face immediately dropped and at that exact moment in time I became invisible, and fanboy began to fanboy Tom. It was priceless!
Good times!
Cheers
Tim…
In today’s video we’ll quickly demonstrate long identifiers, introduced in Oracle database 12.2.
The video is based on this article.
I was moved to make this because I saw someone on Twitter complaining about the 30 character limit in Oracle. I figured they were probably using an old version of the database, but that’s their fault. A short video was convenient, as I was working this weekend, and didn’t have much free time. 🙂
The star of today’s video is Marcelle Kaye, in honour of her recent birthday. Hopefully we will get to meet up again one day…
Cheers
Tim…
In today’s video we demonstrate the JSON data type, introduced in Oracle database 21c.
The video is based on this article.
It assumes knowledge of existing JSON support in the Oracle database. If you are not familiar with the functionality Oracle have been including in the database since Oracle 12c, you might want to check out these.
The star of today’s video is my sister-in-law Maria Colgan. As if being related to me by marriage is not enough of a claim to fame, she is also the current reigning queen of the Oracle database. Long live the Queen!
Cheers
Tim…
In today’s video we’ll demonstrate how to use virtual columns, introduced in Oracle 11g.
The video is based on this article.
The star of today’s video is Scott Wesley of APEX fame. I think he’s into gardening too, because he has a blog about grass or something… 🙂
Cheers
Tim…
In today’s video we’ll demonstrate how to convert a CentOS installation to an Oracle Linux installation.
The video is based on this post.
The star of today’s video is Dan Norris, in a clip from a previous OpenWorld, which seems like a long distant memory now.
Cheers
Tim…
PS. I know I said there would be no more videos this year, but this was very much “of the moment”, so I thought it was worth doing.
In today’s video we’ll discuss read-only partitions and subpartitions, introduced in Oracle 12.2.
This is based on the following article.
You might find these useful too.
The star of today’s video is Chris Saxon of AskTom fame. You can check out his YouTube channel here.
Cheers
Tim…
In today’s video we’ll discuss Invisible Indexes, introduced in Oracle 11g.
The video is based on this article.
The star of today’s video is Chris Muir, who was instrumental in me becoming a presenter. He invited me down to Australia to speak at a couple of AUSOUG events, which were the first proper conferences I ever presented at.
Cheers
Tim…