Search

Top 60 Oracle Blogs

Recent comments

JSON

JSON can be such a TREAT

What better way to start a new week than with a cheesy title to my blog post! Smile

But there is method to my unstructured madness today as we talk about the TREAT function, available from 18C for JSON data. As many of us will already know it is possible to dive into JSON data and extract information from its components as if they were relational columns using the very cool dot notation

In order to do so, we need to be a little generous to the database by letting it know that the contents of a unstructured column such as a CLOB is truly correct JSON data.

I will start with a table with a simple CLOB which does indeed contain valid JSON but I have not let the database know about that fact:

Video : APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data to rows and columns

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.

Video : Oracle REST Data Services (ORDS) : Including Hyperlinks in JSON Output

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.

Video : Oracle REST Data Services (ORDS) : OAuth Implicit

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.

Video : Oracle REST Data Services (ORDS) : REST Enabled SQL

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.

eProseed Oracle Open World 2016 debrief – Oracle Database & Oracle Management Cloud

For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…

Oracle Database 12.2.0.1 – JSON and the In-Memory Database

Here the presentation slide deck (100+) used during the oGH Dutch Usergroup session and (partially…

Scoop – First glance of the new Oracle Live SQL?

When I was at OOW this year I saw the new (?) Oracle Live SQL…

Oracle Database 12.2.0.1 – PL/SQL JSON functionality

One functionality area in Oracle Database 12.2.0.1 that now also supports the handling of JSON…