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 standard database APIs to insert or update JSON data in Oracle Database. You can work directly with JSON data contained in file-system files by creating an external table that exposes it to the database. You can use JSON Merge Patch to update a JSON document.
• Loading External JSON Data
  You can create a database table of JSON data from the content of a JSON dump file.
• Updating a JSON Document with JSON Merge Patch
  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.