The usual ways to insert, update, and load data in Oracle 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 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.