Oracle related rants (and lots of off-topic stuff)…
In today’s video we demonstrate multivalue function-based indexes for JSON_EXISTS, introduced in Oracle 21c.
The video is based on this article.
You may also find these helpful.
The star of today’s video is my sister-in-law and the queen of the database Maria Colgan. It’s a pleasure to be one of your unworthy minions… 🙂
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…
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.
Yet another reason why you should always install APEX in your databases.
The star of today’s video is Kosseila.HD, also known as BrokeDBA, complete with sun glasses, basket ball and a rattling watch. 🙂
Cheers
Tim…
In today’s video we’ll demonstrate how to include hyperlinks in JSON output delivered by Oracle REST Data Services (ORDS).
This is based on this article, which includes some more complete examples.
Good API design is not as simple as you might think, and making sure you pass back relevant information, like URLs for navigating through the services and maybe even service documentation links can make things a lot clearer.
The star of today’s video is James Morle. One of the OGs of performance!
You can check out my ORDS articles and YouTube ORDS playlist here.
Cheers
Tim…
In today’s video we look at the OAuth Implicit flow for Oracle REST Data Services.
This goes together with a previous video about first-party authentication here.
Both videos are based on parts of this article.
There are loads of other ORDS articles here.
The star of today’s video is Bob Rhubart, who amongst other things is the host of the Oracle Groundbreakers Podcast.
Cheers
Tim…
Today’s video is a run through the REST Enabled SQL functionality in Oracle REST Data Services (ORDS).
I wasn’t originally planning on doing this video yet, but the subject of REST Enabled SQL came up a couple of times in the last few days, so I thought I would alter my schedule.
This video is based on the following article, where you can find a lot more examples than are present in the video.
There is a lot more information about ORDS generally in these articles.
The star of today’s video is Emrah Mete, who finished up with an crazy grin. 🙂
Cheers
Tim…
Today’s video is a brief run through the JSON_SERIALIZE function, introduced in Oracle 19c. If you have used any of the other SQL/JSON functions, it’s going to feel pretty familiar.
For those people that prefer there information in written form, you can read about this function here.
The star of this video is Zahid Anwar, or ZedDBA. 🙂
Cheers
Tim…
Today’s video is a run through the JSON_MERGEPATCH function, which was introduced in Oracle 19c.
For those that don’t do video, this was based on the following article.
The star of today’s video is Rene Antunez.
Cheers
Tim…
Today’s video is a demonstration of the JSON_EQUAL condition introduced in Oracle 18c.
If videos aren’t your thing, you can read about it here.
The star of today’s video is Patrick Hurley, being a little over-dramatic. 🙂
Cheers
Tim…
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…