Path Expressions in JSON
Alex Nuijten, Patrick Barel · Apress eBooks · 2023
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 document with easy-to-understand SQL statements.