Using JSON Documents with Autonomous AI Database

Autonomous AI Database has full support for data represented as JSON documents. In Autonomous AI 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 AI Database Simple Oracle Document Access (SODA) is a set of NoSQL-style APIs that let you use collections of JSON documents in Autonomous AI 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 AI Database

  Autonomous AI Database supports JavaScript Object Notation (JSON) data natively in the database.

• Load JSON Documents with Autonomous AI 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 AI Database.

• Import SODA Collection Data Using Oracle Data Pump Version 19.6 or Later

  Shows the steps to import SODA collections into Autonomous AI Database with Oracle Data Pump.