Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

Changes in This Release for Oracle Database JSON Developer's Guide

Part I Introduction to JSON Data and Oracle Database

1 JSON in Oracle Database

2 JSON Data

Part II Store and Manage JSON Data

3 Overview of Storing and Managing JSON Data

4 Creating a Table With a JSON Column

5 SQL/JSON Conditions IS JSON and IS NOT JSON

6 Character Sets and Character Encoding for JSON Data

7 Partitioning JSON Data

8 Replication of JSON Data

Part III Insert, Update, and Load JSON Data

9 Overview of Inserting, Updating, and Loading JSON Data

10 Loading External JSON Data

Part IV Query JSON Data

11 Simple Dot-Notation Access to JSON Data

12 SQL/JSON Functions and Conditions

13 SQL/JSON Path Expressions

14 Clauses Used in SQL/JSON Query Functions and Conditions

15 SQL/JSON Condition JSON_EXISTS

16 SQL/JSON Function JSON_VALUE

17 SQL/JSON Function JSON_QUERY

18 SQL/JSON Function JSON_TABLE

19 JSON Data Guide

Part V Generation of JSON Data

20 Generation of JSON Data With SQL/JSON Functions

Part VI PL/SQL Object Types for JSON

21 Overview of PL/SQL Object Types for JSON

22 Using PL/SQL Object Types for JSON

Part VII GeoJSON Geographic Data

23 Using GeoJSON Geographic Data

Part VIII Performance Tuning for JSON

24 Overview of Performance Tuning for JSON

25 Indexes for JSON Data

26 In-Memory JSON Data

A Oracle Database JSON Restrictions

Index