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_14

14. Generate, Compare, and Manipulate JSON

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

Generating JSON documents from relational data is a common requirement, and Oracle Database offers the necessary tools. This chapter looks at these possibilities in SQL and PL/SQL.

There is also information about working with JSON documents in PL/SQL, like extracting data and making changes to a JSON document.

Generating JSON Documents

To generate JSON documents in SQL, there are several functions available. ...