Using JSON Documents with Autonomous Database

Autonomous Database has full support for data represented as JSON documents. In Autonomous Databases, JSON documents can coexist with relational data.

You can access and manage JSON documents as follows:

• Using Simple Oracle Document Access (SODA) APIs for NoSQL-style access to document collections.
• Using SQL and PL/SQL to access JSON documents in tables.

• Work with Simple Oracle Document Access (SODA) in Autonomous Database
  Simple Oracle Document Access (SODA) is a set of NoSQL-style APIs that let you use collections of JSON documents in Autonomous Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the documents are stored in the database.
• Work with JSON Documents Using SQL and PL/SQL APIs on Autonomous Database
  Autonomous Database supports JavaScript Object Notation (JSON) data natively in the database.
• Load JSON Documents with Autonomous Database
  You can use the PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION to load JSON documents into SODA collections or use DBMS_CLOUD.COPY_DATA to load JSON documents into an existing table in Autonomous Database.
• Import SODA Collection Data Using Oracle Data Pump Version 19.6 or Later
  Shows the steps to import SODA collections into Autonomous Database with Oracle Data Pump.