Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_11

11. Storing JSON in the Database

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

When you work with JSON documents, you must decide if and how you will store JSON in the database. The first decision, if, needs to be made early on. Do you need the JSON document in its original format? You can make the case to do this when you are not storing all the data in relational tables, and the JSON document might contain data that could prove valuable later.

When storing all JSON data in a relational format, ...