© 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 Nuijten1   and Patrick Barel2
Oosterhout, Noord-Brabant, The Netherlands
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 ...

Get Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.