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.
- JSON Data Guide in Oracle Database 12c Release 2 (12.2)
- JSON Data Guide Enhancements in Oracle Database 18c
The cameo in today’s video is Toon Koppelaars of #SMartDB fame.
Cheers
Tim…
PS. Subscribe to my YouTube channel here.
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?
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…