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.


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


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
 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.