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_12

12. Path Expressions in JSON

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

To work effectively with JSON, it is important to start with the basic functionality. One of the most important things to learn is the path expressions, navigating, and targeting the correct JSON keys. Path expressions are needed in SQL as well as in PL/SQL. This chapter introduces the path expression and its filtering capabilities and error handling. Finally, you look at the dot notation to extract values from a JSON ...