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.

Chapters:

• 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. For better performance, you can load the external-table data into an ordinary table.
• Loading External JSON Data
  You can create a database table of JSON data from the content of a JSON dump file.