Load JSON on Autonomous AI Database

The PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION provides support for loading JSON documents into SODA collections. The procedure DBMS_CLOUD.COPY_DATA provides support for loading JSON data into an existing table in Autonomous AI Database.

• About Loading JSON Documents

  You load SODA collections into Autonomous AI Database using the PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION and you load JSON data into a table using DBMS_CLOUD.COPY_DATA.

• Load a JSON File of Line-Delimited Documents into a Collection

  For loading data from collections in the Cloud, you must first store your object storage credentials in your Autonomous AI Database and then use the procedure DBMS_CLOUD.COPY_COLLECTION to load documents into a collection.

• Load an Array of JSON Documents into a Collection

  To load data from collections in the Cloud, you first store your object storage credentials in your Autonomous AI Database and then use PL/SQL procedure DBMS_CLOUD.COPY_COLLECTION to load documents into a collection. This topic explains how to load documents to your database from a JSON array in a file.

• Textual JSON Objects That Represent Extended Scalar Values

  Native binary JSON data (OSON format) extends the JSON language by adding scalar types, such as date, that correspond to SQL types and are not part of the JSON standard. Oracle AI Database also supports the use of textual JSON objects that represent JSON scalar values, including such nonstandard values.

• Create Credentials and Copy JSON Data into an Existing Table

  Use DBMS_CLOUD.COPY_DATA to load JSON data in the cloud into a table.