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_13

13. SQL/JSON and Conditions

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

Having JSON documents stored in the database is one thing, and knowing how to navigate through the document is another, but extracting the data into a relational format is what it is all about.

This chapter focuses on this transformation, creating a relational output from a JSON document using SQL statements.

The examples in this chapter use the sample data from the previous chapter.

SQL/JSON Functions

Four SQL functions ...