Part III Insert, Update, and Load JSON Data

The usual ways to insert, update, and load data in Oracle AI Database work with JSON data. You can also create an external table from the content of a JSON dump file.

• Overview of Inserting, Updating, and Loading JSON Data
  You can use database APIs to insert or modify JSON data in Oracle AI Database. You can use Oracle SQL function json_transform or json_mergepatch to update a JSON document. You can work directly with JSON data contained in file-system files by creating an external table that exposes it to the database.
• Oracle SQL Function JSON_TRANSFORM
  Oracle SQL function json_transform modifies JSON data. It allows multiple modification operations in a single invocation.
• Oracle SQL Function JSON_MERGEPATCH
  You can use Oracle SQL function json_mergepatch to update specific portions of a JSON document. You pass it a JSON Merge Patch document, which specifies the changes to make to a specified JSON document. JSON Merge Patch is an IETF standard.
• Loading External JSON Data
  You can create a database table of JSON data from a file-system file containing textual JSON documents.