March/April 2018 Oracle Database 12c Release 1 ushered in a new age of JSON inside Oracle Database through wide-ranging and smart support of JSON documents in SQL.
You can use SQL to join JSON data with relational data.
He was one of the original Oracle ACE Directors and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 20.
You can use the object types to programmatically manipulate JSON data in memory, to do things such as the following: Overview The primary PL/SQL JSON object types you will use are JSON_ELEMENT_T, JSON_OBJECT_T, JSON_ARRAY_T, and JSON_SCALAR_T. Instead, you first read data from a table into the appropriate instances of the object types or construct the instances through parsing and other operations directly in your PL/SQL code.
You can “project” JSON data relationally, extracting content from within the JSON document, thereby making it available for relational processes and tools.