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.

Author: Tim...

DBA, Developer, Author, Trainer.

2 thoughts on “Video : JSON Data Guide”

  1. I have a standard procedure that I use to frequently access web services, JSON is a format that I know in the context of web development, but what is the best way to work with json inside a stored procedure? For example, take the CLOB response from a URI, convert it to a JSON object and get the value from it?

  2. Hi.

    Pre-12c I would say use APEX_JSON package.
    https://oracle-base.com/articles/misc/apex_json-package-generate-and-parse-json-documents-in-oracle

    12cR1 you also have the option to use JSON_TABLE.
    https://oracle-base.com/articles/12c/json-support-in-oracle-database-12cr1#json_table

    12cR2 onward, you also have the option to use the PL/SQL Object Type for JSON.
    https://oracle-base.com/articles/12c/plsql-object-types-for-json-12cr2

    Although it’s an ORDS article, this article gives an example of all three handling JSON coming into a procedure as a parameter.

    https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-restful-web-services-handling-complex-json-payloads#create-api-apex-json

    Cheers

    Tim…

Comments are closed.