How to Load JSON Data as JSON Data Types Using External Tables
(Doc ID 2992688.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 23.4 and laterOracle Database - Standard Edition - Version 23.4 and later
Information in this document applies to any platform.
Goal
This document guides how to load JSON data as JSON data types using external tables.
NOTE:New feature to load as JSON data type into an external table add in Oracle Database 23ai.
Reference information:
Oracle® Database Oracle Database New Features Release 23ai
JSON Type Support for External Tables
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application_development.html#GUID-85244-14
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| 1. Load as a JSON Data Type into an External Table |
| 2. Loading JSON Data From External Tables |
| [A]Load the JSON data directly into JSON columns. |
| [B]Use the built JSON functions to convert the JSON data into rows and columns in relation tables. |