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 procedureDBMS_CLOUD.COPY_COLLECTION
to load JSON documents into SODA collections or useDBMS_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.
Parent topic: Develop