14.2.4 Working with JSON in PL/SQL

Use PL/SQL JSON types to parse, build, and serialize JSON data.

• Parsing JSON in PL/SQL
  Parse JSON text into PL/SQL JSON objects and arrays, then access their values by type.
• Treating an Element More Specifically
  Use TREAT to work with a generic JSON element as a more specific PL/SQL JSON type.
• Constructing JSON in PL/SQL
  Build JSON objects and arrays in PL/SQL by adding properties and array elements.
• Serializing JSON in PL/SQL
  Serialize PL/SQL JSON objects to text with STRINGIFY or TO_CLOB, depending on size.