My Oracle Support Banner

How to Load JSON Data as JSON Data Types Using External Tables (Doc ID 2992688.1)

Last updated on JANUARY 30, 2024

Applies to:

Oracle Database - Enterprise Edition - Version Beta 23c and later
Oracle Database - Standard Edition - Version Beta 23c 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 23c.

Reference information:
Oracle® Database Oracle Database New Features Release 23c
JSON Type Support for External Tables
https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-D0F68647-5FE8-41A6-B01C-CBDFC8FD7756

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.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.